APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PER_ALL_ASSIGNMENTS_F

Line 260: n_prev_assignment_id per_all_assignments_f.assignment_id%type;

256: l_proc VARCHAR2(61) := g_package || 'DERIVE_PENSIONABLE_PAY';
257: n_object_version_no number;
258: l_eff_start_date_op date;
259: l_eff_end_date_op date;
260: n_prev_assignment_id per_all_assignments_f.assignment_id%type;
261: l_ELEMENT_NAME pay_element_types_f.ELEMENT_NAME%TYPE;
262:
263: -- This cursor will fetch assignment ids
264: -- based on the payroll id or assignment id or employee number or assignment set id whichever entered by the user

Line 270: FROM per_all_assignments_f paaf,

266: CURSOR c_all_valid_assignment
267: IS
268: SELECT paaf.assignment_id, paaf.assignment_number,
269: paaf.payroll_id, MIN(paaf.EFFECTIVE_START_DATE) EFFECTIVE_START_DATE
270: FROM per_all_assignments_f paaf,
271: per_all_people_f papf,
272: per_assignment_status_types past
273: WHERE paaf.business_group_id = p_business_group_id
274: AND paaf.payroll_id= nvl(p_payroll_id, paaf.payroll_id)