DBA Data[Home] [Help]

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