APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 1571: from pay_action_interlocks pai_v,

1567: and decode(ppa.action_type,'R','TRM',nvl(per_jp_empdet_archive_pkg.get_fuzzy_proc_type(paa.assignment_action_id),'X')) = 'TRM'
1568: and not exists(
1569: select /*+ ORDERED */
1570: null
1571: from pay_action_interlocks pai_v,
1572: pay_assignment_actions paa_v,
1573: pay_payroll_actions ppa_v
1574: where pai_v.locked_action_id = paa.assignment_action_id
1575: and paa_v.assignment_action_id = pai_v.locking_action_id