APPS.PSP_ADJ_DRIVER dependencies on HR_ALL_ORGANIZATION_UNITS
Line 1406: FROM hr_all_organization_units haou,
1402:
1403:
1404: CURSOR assign_org_name_cur IS
1405: SELECT name 1406: FROM hr_all_organization_units haou, 1407: per_assignments_f paf
1408: WHERE haou.organization_id = paf.organization_id
1409: AND paf.assignment_id = l_assignment_id
1410: AND TRUNC(SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date;