APPS.PAY_GB_RETRO_UPGRADE dependencies on PAY_PAYROLL_ACTIONS

Line 191: from pay_payroll_actions ppa

187: and petr.include_or_exclude = 'E';
188:
189: cursor c_element_check(cp_element_set_id in number) is
190: select 1
191: from pay_payroll_actions ppa
192: where ppa.action_type = 'L'
193: and ppa.element_set_id = cp_element_set_id;
194:
195: cursor c_retro_rule_check(cp_rule_type in varchar2

Line 389: and exists (select 1 from pay_payroll_actions ppa

385: and hoi.org_information1 = 'HR_BG'
386: and hoi.organization_id = hoi2.organization_id
387: and hoi2.org_information_context = 'Business Group Information'
388: and hoi2.org_information9 = cp_legislation_code
389: and exists (select 1 from pay_payroll_actions ppa
390: where ppa.business_group_id = hoi.organization_id
391: and ppa.action_type = 'L'
392: and ppa.element_set_id = cp_element_set_id
393: );