DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_PAYROLL_ACTIONS

Line 1782: from pay_payroll_actions ppa

1778: /* Chechk whether Element set is used for retropayment */
1779:
1780: cursor c_element_check(cp_element_set_id in number) is
1781: select 1
1782: from pay_payroll_actions ppa
1783: where ppa.action_type = 'L'
1784: and ppa.element_set_id = cp_element_set_id;
1785:
1786: cursor c_retro_rule_check(cp_rule_type in varchar2

Line 2010: and exists (select 1 from pay_payroll_actions ppa

2006: and hoi.org_information1 = 'HR_BG'
2007: and hoi.organization_id = hoi2.organization_id
2008: and hoi2.org_information_context = 'Business Group Information'
2009: and hoi2.org_information9 = cp_legislation_code
2010: and exists (select 1 from pay_payroll_actions ppa
2011: where ppa.business_group_id = hoi.organization_id
2012: and ppa.action_type = 'L'
2013: and ppa.element_set_id = cp_element_set_id
2014: );