DBA Data[Home] [Help]

APPS.PAY_IN_REPORTS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 3634: FROM hr_all_organization_units hou

3630: /* Cursor to find out the list of Archived Exempted PF Organizations */
3631: CURSOR csr_exempted_pf_orglist
3632: IS
3633: SELECT hou.organization_id orgid
3634: FROM hr_all_organization_units hou
3635: ,hr_organization_information hoi
3636: WHERE hou.organization_id = hoi.organization_id
3637: AND hoi.org_information_context ='PER_IN_PF_DF'
3638: AND hou.organization_id like nvl(p_pf_org_id,'%')