APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 2649: pay_all_payrolls_f papf,

2645:
2646: CURSOR cur_max_end_date IS
2647: SELECT max(paaf.effective_end_date)
2648: FROM per_all_assignments_f paaf,
2649: pay_all_payrolls_f papf,
2650: hr_soft_coding_keyflex scl
2651: WHERE paaf.person_id = p_person_id
2652: AND paaf.payroll_id = papf.payroll_id
2653: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 2832: pay_all_payrolls_f papf,

2828: same per_system_status (5073577) */
2829: CURSOR cur_max_end_date IS
2830: SELECT max(paaf.effective_end_date)
2831: FROM per_all_assignments_f paaf,
2832: pay_all_payrolls_f papf,
2833: hr_soft_coding_keyflex scl
2834: WHERE paaf.person_id = p_person_id
2835: AND paaf.payroll_id = papf.payroll_id
2836: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 3251: FROM pay_all_payrolls_f ppf,

3247: hrl.address_line_2 employer_tax_addr2,
3248: hrl.address_line_3 employer_tax_addr3,
3249: hrl.telephone_number_1 employer_tax_ref_phone
3250: --
3251: FROM pay_all_payrolls_f ppf,
3252: pay_payroll_actions pact,
3253: hr_organization_information org,
3254: hr_soft_coding_keyflex flex,
3255: hr_organization_units hou,

Line 3736: pay_all_payrolls_f papf,

3732: /* check person does not hold employment with the employer between start of year and archive end date */
3733: AND NOT EXISTS (
3734: SELECT MIN(paf.effective_start_date),MAX(paf.effective_end_date)
3735: FROM per_all_assignments_f paf,
3736: pay_all_payrolls_f papf,
3737: hr_soft_coding_keyflex scl
3738: WHERE paf.person_id = as1.person_id
3739: AND paf.payroll_id = papf.payroll_id
3740: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to