DBA Data[Home] [Help]

APPS.HR_MISC_WEB dependencies on HR_LOCATIONS

Line 588: FROM hr_locations hl,

584: p_effective_date IN DATE
585: ) IS
586: SELECT hl.location_id,
587: hl.location_code
588: FROM hr_locations hl,
589: per_all_assignments_f paf
590: WHERE paf.assignment_id = p_assignment_id
591: AND paf.location_id = hl.location_id
592: -- AND paf.primary_flag = 'Y' -- To supprot multiple assignments