APPS.PQP_GB_PCSPS_PENSIONPAY dependencies on PER_ALL_ASSIGNMENTS_F

Line 298: n_prev_assignment_id per_all_assignments_f.assignment_id%type;

294: l_proc VARCHAR2(61) := g_package || 'DERIVE_PENSIONABLE_PAY';
295: n_object_version_no number;
296: l_eff_start_date_op date;
297: l_eff_end_date_op date;
298: n_prev_assignment_id per_all_assignments_f.assignment_id%type;
299: l_ELEMENT_NAME pay_element_types_f.ELEMENT_NAME%TYPE;
300:
301: -- This cursor will fetch assignment ids
302: -- based on the payroll id or assignment id or employee number or assignment set id whichever entered by the user

Line 308: FROM per_all_assignments_f paaf,

304: CURSOR c_all_valid_assignment
305: IS
306: SELECT paaf.assignment_id, paaf.assignment_number,
307: paaf.payroll_id, MIN(paaf.EFFECTIVE_START_DATE) EFFECTIVE_START_DATE
308: FROM per_all_assignments_f paaf,
309: per_all_people_f papf,
310: per_assignment_status_types past
311: WHERE paaf.business_group_id = p_business_group_id
312: AND paaf.payroll_id= nvl(p_payroll_id, paaf.payroll_id)

Line 447: cursor c_pqp_element_entry_id(p_element_type_id number,p_assignment_id per_all_assignments_f.assignment_id%type)

443: and petf.business_group_id = p_business_group_id
444: and v_assignment_eff_date between petf.EFFECTIVE_START_DATE and petf.EFFECTIVE_END_DATE;
445:
446: --This cursor to fetch element_entry_id
447: cursor c_pqp_element_entry_id(p_element_type_id number,p_assignment_id per_all_assignments_f.assignment_id%type)
448: is
449: select element_entry_id
450: from pay_element_entries_f peef
451: where peef.element_type_id = p_element_type_id