IGI Secondary Invoice Approval : Flexfield Assignments - draft

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