IGI Secondary Invoice Approval : Flexfield Assignments - draft

Description
Categories: BI Publisher, Financials
Application: Public Sector Financials International
Source: Secondary Invoice Approval : Flexfield Assignments (XML) - Not Supported: Reserved For Future Use
Short Name: IGIPSIAP_XML
DB package: IGI_IGIPSIAP_XMLP_PKG
SELECT        g.group_name,
        f.user_name,
        emp.full_name,
        d.start_date_active,
        d.end_date_active,
        d.approver_id,
        g.group_id
FROM    igi_sap_group g,
        igi_sap_department_approvers d,
        fnd_user f,
        hr_employees emp
WHERE   g.group_id = d.group_id
AND     g.group_id = nvl(:p_approval_group,g.group_id)
AND     f.user_id = d.approver_id
AND     d.approver_id = nvl(:p_approver,d.approver_id)
AND     f.employee_id = emp.employee_id (+)
AND     exists
        (select 1
        from     igi_sap_app_ranges p1
                where  p1.approver_id = d.approver_id
        and      p1.group_id = g.group_id
        and     &P_WHERES)         
order   by 1,2
Parameter NameSQL textValidation
Chart of Accounts
 
LOV Oracle
GL_SRS_NULL_NUM
 
Number
Flexfield To
 
Flexfield From
 
Approver
 
LOV Oracle
Approval Group
 
LOV Oracle