APPS.PQP_GB_LGPS_PENSIONPAY dependencies on PER_ALL_ASSIGNMENTS_F

Line 272: n_prev_assignment_id per_all_assignments_f.assignment_id%type;

268: l_proc VARCHAR2(61) := g_package || 'DERIVE_PENSIONABLE_PAY';
269: n_object_version_no number;
270: l_eff_start_date_op date;
271: l_eff_end_date_op date;
272: n_prev_assignment_id per_all_assignments_f.assignment_id%type;
273: l_ELEMENT_NAME pay_element_types_f.ELEMENT_NAME%TYPE;
274:
275: -- This cursor will fetch assignment ids
276: -- based on the payroll id or assignment id or employee number or assignment set id whichever entered by the user

Line 282: FROM per_all_assignments_f paaf,

278: CURSOR c_all_valid_assignment
279: IS
280: SELECT paaf.assignment_id, paaf.assignment_number,
281: paaf.payroll_id, MIN(paaf.EFFECTIVE_START_DATE) EFFECTIVE_START_DATE
282: FROM per_all_assignments_f paaf,
283: per_all_people_f papf,
284: per_assignment_status_types past
285: WHERE paaf.business_group_id = p_business_group_id
286: AND paaf.payroll_id= nvl(p_payroll_id, paaf.payroll_id)