DBA Data[Home] [Help]

APPS.PAY_GB_HIST_ARCH_PKG dependencies on PAY_ACTION_INFORMATION

Line 155: from pay_action_information pai

151: and ppa1.business_group_id = ppa.business_group_id
152: and ppa1.action_type IN ('U','P')
153: and not exists (
154: select 1
155: from pay_action_information pai
156: where pai.action_context_id = paa.assignment_action_id
157: and pai.action_context_type = 'AAP'
158: and pai.assignment_id = paa.assignment_id
159: and pai.action_information_category = 'GB ELEMENT PAYSLIP INFO')