DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on HR_SOFT_CODING_KEYFLEX

Line 1388: hr_soft_coding_keyflex hsck

1384: select count(DISTINCT ptp.time_period_id)
1385: from per_time_periods ptp
1386: where exists (select 'EXISTS' from
1387: per_assignments_f paf,
1388: hr_soft_coding_keyflex hsck
1389: where paf.assignment_id = p_assignment_id
1390: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
1391: and hsck.segment1 = c_tax_unit_id
1392: AND paf.effective_start_date <= c_end_date