DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPE_RULES

Line 1548: from pay_element_type_rules petr

1544: cursor c_element_set(cp_element_type_id in number
1545: ,cp_classification_id in number
1546: ,cp_legislation_code in varchar2) is
1547: select petr.element_set_id
1548: from pay_element_type_rules petr
1549: where petr.element_type_id = cp_element_type_id
1550: and petr.include_or_exclude = 'I'
1551: union all
1552: select pes.element_set_id

Line 1564: from pay_element_type_rules petr

1560: and pet.element_type_id = cp_element_type_id
1561: and pecr.classification_id = cp_classification_id
1562: minus
1563: select petr.element_set_id
1564: from pay_element_type_rules petr
1565: where petr.element_type_id = cp_element_type_id
1566: and petr.include_or_exclude = 'E'
1567: ;
1568:

Line 1777: from pay_element_type_rules petr

1773: cursor c_element_set(cp_element_type_id in number
1774: ,cp_classification_id in number
1775: ,cp_legislation_code in varchar2) is
1776: select petr.element_set_id
1777: from pay_element_type_rules petr
1778: where petr.element_type_id = cp_element_type_id
1779: and petr.include_or_exclude = 'I'
1780: union all
1781: select pes.element_set_id

Line 1793: from pay_element_type_rules petr

1789: and pet.element_type_id = cp_element_type_id
1790: and pecr.classification_id = cp_classification_id
1791: minus
1792: select petr.element_set_id
1793: from pay_element_type_rules petr
1794: where petr.element_type_id = cp_element_type_id
1795: and petr.include_or_exclude = 'E';
1796:
1797: cursor c_get_business_group(cp_element_set_id in number