DBA Data[Home] [Help]

APPS.PAY_IE_CESS_REPORT dependencies on HR_SOFT_CODING_KEYFLEX

Line 157: hr_soft_coding_keyflex scl

153: CURSOR cur_max_end_date IS
154: SELECT max(paaf.effective_end_date)
155: FROM per_all_assignments_f paaf,
156: pay_all_payrolls_f papf,
157: hr_soft_coding_keyflex scl
158: WHERE paaf.person_id = p_person_id
159: AND paaf.payroll_id = papf.payroll_id
160: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
161: AND scl.segment4 = to_char(g_paye_ref)

Line 1693: hr_soft_coding_keyflex scl

1689: AND NOT EXISTS (
1690: SELECT MIN(paf.effective_start_date),MAX(paf.effective_end_date)
1691: FROM per_all_assignments_f paf,
1692: pay_all_payrolls_f papf,
1693: hr_soft_coding_keyflex scl
1694: WHERE paf.person_id = as1.person_id
1695: AND paf.payroll_id = papf.payroll_id
1696: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
1697: same per_system_status (5073577) */