DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 316: , hr_all_organization_units org

312: hoi.org_information2,
313: hoi.org_information3,
314: hoi.org_information4
315: from hr_organization_information hoi
316: , hr_all_organization_units org
317: where hoi.org_information_context = 'ZA_UIF_CREATOR_INFO'
318: and hoi.organization_id = org.organization_id
319: and org.organization_id = g_business_group_id;
320: /*Commented out the following to allow re-archiving*/

Line 1002: hr_all_organization_units org

998: hoi.org_information10 Employer_email_Address,
999:
1000: hoi.org_information3 Employer_PAYE_Number
1001: from hr_organization_information hoi,
1002: hr_all_organization_units org
1003: where org.organization_id = p_org_id
1004: and org.organization_id = hoi.organization_id
1005: and hoi.org_information_context = 'ZA_LEGAL_ENTITY';
1006: