DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4_AMEND_REG dependencies on PAY_ACTION_INTERLOCKS

Line 414: from pay_action_interlocks

410: and ppa.payroll_action_id = paa.payroll_action_id
411: and ppa.effective_date = cp_effective_date
412: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
413: and not exists (select 1
414: from pay_action_interlocks
415: where locked_action_id = paa.assignment_action_id)
416: and exists (select 1
417: from per_assignments_f paf
418: where paf.assignment_id = paa.assignment_id