188: and petr.include_or_exclude = 'E';
189:
190: cursor c_element_check(cp_element_set_id in number) is
191: select 1
192: from pay_payroll_actions ppa
193: where ppa.action_type = 'L'
194: and ppa.element_set_id = cp_element_set_id;
195:
196: cursor c_retro_rule_check(cp_rule_type in varchar2
344: and hoi.org_information1 = 'HR_BG'
345: and hoi.organization_id = hoi2.organization_id
346: and hoi2.org_information_context = 'Business Group Information'
347: and hoi2.org_information9 = cp_legislation_code
348: and exists (select 1 from pay_payroll_actions ppa
349: where ppa.business_group_id = hoi.organization_id
350: and ppa.action_type = 'L'
351: and ppa.element_set_id = cp_element_set_id
352: );