APPS.PAY_IE_P45_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 2650: hr_soft_coding_keyflex scl

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

Line 2833: hr_soft_coding_keyflex scl

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

Line 3254: hr_soft_coding_keyflex flex,

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

Line 3737: hr_soft_coding_keyflex scl

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