DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPE_RULES

Line 1757: from pay_element_type_rules petr

1753: cursor c_element_set(cp_element_type_id in number
1754: ,cp_classification_id in number
1755: ,cp_legislation_code in varchar2) is
1756: select petr.element_set_id
1757: from pay_element_type_rules petr
1758: where petr.element_type_id = cp_element_type_id
1759: and petr.include_or_exclude = 'I'
1760: union all
1761: select pes.element_set_id

Line 1773: from pay_element_type_rules petr

1769: and pet.element_type_id = cp_element_type_id
1770: and pecr.classification_id = cp_classification_id
1771: minus
1772: select petr.element_set_id
1773: from pay_element_type_rules petr
1774: where petr.element_type_id = cp_element_type_id
1775: and petr.include_or_exclude = 'E'
1776: ;
1777:

Line 1980: from pay_element_type_rules petr

1976: cursor c_element_set(cp_element_type_id in number
1977: ,cp_classification_id in number
1978: ,cp_legislation_code in varchar2) is
1979: select petr.element_set_id
1980: from pay_element_type_rules petr
1981: where petr.element_type_id = cp_element_type_id
1982: and petr.include_or_exclude = 'I'
1983: union all
1984: select pes.element_set_id

Line 1996: from pay_element_type_rules petr

1992: and pet.element_type_id = cp_element_type_id
1993: and pecr.classification_id = cp_classification_id
1994: minus
1995: select petr.element_set_id
1996: from pay_element_type_rules petr
1997: where petr.element_type_id = cp_element_type_id
1998: and petr.include_or_exclude = 'E';
1999:
2000: cursor c_get_business_group(cp_element_set_id in number