APPS.PAY_IP_RETRO_UPGRADE dependencies on PAY_PAYROLL_ACTIONS

Line 177: from pay_payroll_actions ppa

173: and petr.include_or_exclude = 'E';
174:
175: cursor c_element_check(cp_element_set_id in number) is
176: select 1
177: from pay_payroll_actions ppa
178: where ppa.action_type = 'L'
179: and ppa.element_set_id = cp_element_set_id;
180:
181: ln_classification_id NUMBER;

Line 306: and exists (select 1 from pay_payroll_actions ppa

302: and hoi.org_information1 = 'HR_BG'
303: and hoi.organization_id = hoi2.organization_id
304: and hoi2.org_information_context = 'Business Group Information'
305: and hoi2.org_information9 = cp_legislation_code
306: and exists (select 1 from pay_payroll_actions ppa
307: where ppa.business_group_id = hoi.organization_id
308: and ppa.action_type = 'L'
309: and ppa.element_set_id = cp_element_set_id
310: );