APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 1982: pay_all_payrolls_f papf,

1978:
1979: CURSOR cur_max_end_date IS
1980: SELECT max(paaf.effective_end_date)
1981: FROM per_all_assignments_f paaf,
1982: pay_all_payrolls_f papf,
1983: hr_soft_coding_keyflex scl
1984: WHERE paaf.person_id = p_person_id
1985: AND paaf.payroll_id = papf.payroll_id
1986: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 2165: pay_all_payrolls_f papf,

2161: same per_system_status (5073577) */
2162: CURSOR cur_max_end_date IS
2163: SELECT max(paaf.effective_end_date)
2164: FROM per_all_assignments_f paaf,
2165: pay_all_payrolls_f papf,
2166: hr_soft_coding_keyflex scl
2167: WHERE paaf.person_id = p_person_id
2168: AND paaf.payroll_id = papf.payroll_id
2169: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 2545: FROM pay_all_payrolls_f ppf,

2541: hrl.address_line_2 employer_tax_addr2,
2542: hrl.address_line_3 employer_tax_addr3,
2543: hrl.telephone_number_1 employer_tax_ref_phone
2544: --
2545: FROM pay_all_payrolls_f ppf,
2546: pay_payroll_actions pact,
2547: hr_organization_information org,
2548: hr_soft_coding_keyflex flex,
2549: hr_organization_units hou,

Line 3028: pay_all_payrolls_f papf,

3024: /* check person does not hold employment with the employer between start of year and archive end date */
3025: AND NOT EXISTS (
3026: SELECT MIN(paf.effective_start_date),MAX(paf.effective_end_date)
3027: FROM per_all_assignments_f paf,
3028: pay_all_payrolls_f papf,
3029: hr_soft_coding_keyflex scl
3030: WHERE paf.person_id = as1.person_id
3031: AND paf.payroll_id = papf.payroll_id
3032: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to