APPS.PAY_IE_P45_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 1983: hr_soft_coding_keyflex scl

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
1987: AND scl.segment4 = to_char(g_paye_ref)

Line 2166: hr_soft_coding_keyflex scl

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
2170: AND scl.segment4 = to_char(g_paye_ref)

Line 2548: hr_soft_coding_keyflex flex,

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,
2550: hr_locations_all hrl
2551: WHERE org.org_information_context = 'IE_EMPLOYER_INFO' -- for migration changes 4369280
2552: AND ppf.business_group_id = hou.business_group_id

Line 3029: hr_soft_coding_keyflex scl

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
3033: same per_system_status (5073577) */