DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on PAY_ACTION_INTERLOCKS

Line 377: from pay_action_interlocks

373: and ppa.payroll_action_id = paa.payroll_action_id
374: and ppa.effective_date = cp_effective_date
375: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
376: and not exists (select 1
377: from pay_action_interlocks
378: where locked_action_id = paa.assignment_action_id)
379: and exists (select 1
380: from per_assignments_f paf
381: where paf.assignment_id = paa.assignment_id