DBA Data[Home] [Help]

APPS.GHR_CREATE_PTNL_LIFE_EVENTS dependencies on HR_LOCATION_EXTRA_INFO

Line 50: from hr_location_extra_info lei,

46:
47: Cursor c_get_ds_code is
48: select lei.lei_information3,
49: dut.duty_station_code
50: from hr_location_extra_info lei,
51: per_all_assignments_f asg,
52: ghr_duty_stations_v dut
53: where p_pa_request_rec.employee_assignment_id = asg.assignment_id
54: and p_pa_request_rec.effective_date between