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'