DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on PAY_ACTION_INTERLOCKS

Line 389: from pay_action_interlocks

385: and ppa.effective_date = cp_effective_date
386: and ppa.business_group_id = cp_business_group_id
387: and ppa.report_type = 'CAEOY_RL1_AMEND_PP'
388: and not exists (select 1
389: from pay_action_interlocks
390: where locked_action_id = paa.assignment_action_id)
391: and exists (select 1
392: from per_assignments_f paf
393: where paf.assignment_id = paa.assignment_id