APPS.PAY_GB_ENROLL_PENSION dependencies on HR_ALL_ORGANIZATION_UNITS
Line 1812: HR_ALL_ORGANIZATION_UNITS u
1808: CURSOR c_organization(p_org_name VARCHAR2)
1809: IS
1810: SELECT 1
1811: FROM per_all_assignments_f a, 1812: HR_ALL_ORGANIZATION_UNITS u 1813: WHERE assignment_id =p_assignment_id
1814: AND u.ORGANIZATION_ID = a.ORGANIZATION_ID
1815: AND u.business_group_id=g_business_group_id
1816: AND u.name =p_org_name