DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on HR_SOFT_CODING_KEYFLEX

Line 1484: hr_soft_coding_keyflex hsck

1480: select count(DISTINCT ptp.time_period_id)
1481: from per_time_periods ptp
1482: where exists (select 'EXISTS' from
1483: per_assignments_f paf,
1484: hr_soft_coding_keyflex hsck
1485: where paf.assignment_id = p_assignment_id
1486: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
1487: and hsck.segment1 = c_tax_unit_id
1488: AND paf.effective_start_date <= c_end_date