DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_PAYROLL_ACTIONS

Line 1573: from pay_payroll_actions ppa

1569: /* Chechk whether Element set is used for retropayment */
1570:
1571: cursor c_element_check(cp_element_set_id in number) is
1572: select 1
1573: from pay_payroll_actions ppa
1574: where ppa.action_type = 'L'
1575: and ppa.element_set_id = cp_element_set_id;
1576:
1577: cursor c_retro_rule_check(cp_rule_type in varchar2

Line 1807: and exists (select 1 from pay_payroll_actions ppa

1803: and hoi.org_information1 = 'HR_BG'
1804: and hoi.organization_id = hoi2.organization_id
1805: and hoi2.org_information_context = 'Business Group Information'
1806: and hoi2.org_information9 = cp_legislation_code
1807: and exists (select 1 from pay_payroll_actions ppa
1808: where ppa.business_group_id = hoi.organization_id
1809: and ppa.action_type = 'L'
1810: and ppa.element_set_id = cp_element_set_id
1811: );