APPS.PAY_ETP_BUS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 990: from pay_element_classifications

986:
987: Cursor c_non_payments
988: is
989: select non_payments_flag
990: from pay_element_classifications
991: where classification_id = p_classification_id;
992:
993: Cursor c_leg_rule_currency
994: is

Line 1120: from pay_element_classifications

1116: l_exists varchar2(1);
1117: Cursor c_get_class_bal_init
1118: is
1119: select '1'
1120: from pay_element_classifications
1121: where classification_id = p_classification_id
1122: and nvl(balance_initialization_flag,'N') = 'Y';
1123: --
1124: Begin

Line 1659: l_high_priority pay_element_classifications.default_high_priority%type;

1655: ,p_processing_priority_warning out nocopy boolean
1656: ) is
1657: --
1658: l_proc varchar2(72) := g_package||'chk_processing_priority';
1659: l_high_priority pay_element_classifications.default_high_priority%type;
1660: l_low_priority pay_element_classifications.default_low_priority%type;
1661: Cursor c_get_ele_class_priority
1662: is
1663: select default_high_priority,

Line 1660: l_low_priority pay_element_classifications.default_low_priority%type;

1656: ) is
1657: --
1658: l_proc varchar2(72) := g_package||'chk_processing_priority';
1659: l_high_priority pay_element_classifications.default_high_priority%type;
1660: l_low_priority pay_element_classifications.default_low_priority%type;
1661: Cursor c_get_ele_class_priority
1662: is
1663: select default_high_priority,
1664: default_low_priority

Line 1665: from pay_element_classifications

1661: Cursor c_get_ele_class_priority
1662: is
1663: select default_high_priority,
1664: default_low_priority
1665: from pay_element_classifications
1666: where classification_id = p_classification_id;
1667: --
1668: Begin
1669: hr_utility.set_location('Entering:'||l_proc, 5);