DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on PAY_ACTION_INTERLOCKS

Line 373: from pay_action_interlocks

369: and ppa.effective_date = cp_effective_date
370: and ppa.business_group_id = cp_business_group_id
371: and ppa.report_type = 'CAEOY_RL2_AMEND_PP'
372: and not exists (select 1
373: from pay_action_interlocks
374: where locked_action_id = paa.assignment_action_id)
375: and exists (select 1
376: from per_assignments_f paf
377: where paf.assignment_id = paa.assignment_id