DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 315: , hr_all_organization_units org

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

Line 1000: hr_all_organization_units org

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