DBA Data[Home] [Help]

APPS.GHR_CREATE_PTNL_LIFE_EVENTS dependencies on GHR_DUTY_STATIONS_V

Line 52: ghr_duty_stations_v dut

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
55: asg.effective_Start_date and asg.effective_end_date
56: and asg.location_id = lei.location_id