APPS.GHR_CREATE_PTNL_LIFE_EVENTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 25: l_assignment_id per_all_assignments_f.assignment_id%type;

21: l_prior_work_schedule per_assignment_extra_info.aei_information7%type;
22: l_asg_ei_data per_assignment_extra_info%rowtype;
23: l_session ghr_history_api.g_session_var_type;
24: l_proc varchar2(75) := 'create_ptnl_ler_for_per';
25: l_assignment_id per_all_assignments_f.assignment_id%type;
26: l_hire Boolean;
27:
28:
29: l_prog_count number;

Line 51: per_all_assignments_f asg,

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
55: asg.effective_Start_date and asg.effective_end_date