APPS.PQP_GB_PSI_SCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 12: g_assignment_dtl per_all_assignments_f%rowtype;

8: g_person_id NUMBER := NULL;
9: g_business_group_id NUMBER := NULL; -- IMPORTANT TO KEEP NULL
10: g_assignment_id NUMBER := NULL; -- IMPORTANT TO KEEP NULL
11: g_person_dtl per_all_people_f%rowtype;
12: g_assignment_dtl per_all_assignments_f%rowtype;
13: g_altkey VARCHAR2(12) := NULL;
14: g_current_run VARCHAR2(20) := NULL;
15: g_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
16: g_pension_element_type_id NUMBER;

Line 45: cursor csr_lgps_pension_change(p_assignment_id in per_all_assignments_f.assignment_id%type, p_effective_date in DATE)

41: effective_start_date DATE ,
42: effective_end_date DATE ,
43: element_type_id NUMBER );
44:
45: cursor csr_lgps_pension_change(p_assignment_id in per_all_assignments_f.assignment_id%type, p_effective_date in DATE)
46: is
47: select
48: lgps_pensionable_pay pensionable_pay,
49: effective_start_date,