DBA Data[Home] [Help]

APPS.PAY_IN_REPORTS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4353: FROM hr_all_organization_units hou

4349: /* Cursor to find out the list of Archived Exempted PF Organizations */
4350: CURSOR csr_exempted_pf_orglist
4351: IS
4352: SELECT hou.organization_id orgid
4353: FROM hr_all_organization_units hou
4354: ,hr_organization_information hoi
4355: WHERE hou.organization_id = hoi.organization_id
4356: AND hoi.org_information_context ='PER_IN_PF_DF'
4357: AND hou.organization_id like nvl(p_pf_org_id,'%')