DBA Data[Home] [Help]

APPS.PAY_IE_HIST_ARCH_PKG dependencies on PAY_ACTION_INFORMATION

Line 149: from pay_action_information pai

145: and ppa1.business_group_id = ppa.business_group_id
146: and ppa1.action_type IN ('U','P')
147: and not exists (
148: select 1
149: from pay_action_information pai
150: where pai.action_context_id = paa.assignment_action_id
151: and pai.action_context_type = 'AAP'
152: and pai.assignment_id = paa.assignment_id
153: and pai.action_information_category = 'EMEA ELEMENT INFO'