DBA Data[Home] [Help]

APPS.NTG_EARNINGS_TEMPLATE dependencies on PAY_BALANCE_TYPES

Line 119: FROM pay_balance_types pbt

115: AND piv.business_group_id + 0 = p_bg_id;
116: --
117: CURSOR c_get_bal_id IS -- Gets the Balance type id
118: SELECT balance_type_id
119: FROM pay_balance_types pbt
120: WHERE pbt.balance_name = p_object_name
121: AND NVL(pbt.business_group_id, p_bg_id) = p_bg_id
122: AND NVL(pbt.legislation_code, p_legislation_code) = p_legislation_code;
123: --

Line 163: from pay_balance_types

159: --
160: BEGIN
161: select 'Y'
162: into l_reserved
163: from pay_balance_types
164: where p_ele_name = balance_name -- Bug 3350067
165: and nvl(legislation_code, 'US') = 'US'
166: and nvl(business_group_id, p_bg_id) = p_bg_id;
167: