APPS.PAY_ELEMENT_TEMPLATE_USER_INIT dependencies on PAY_BALANCE_TYPES

Line 246: FROM pay_balance_types pbt,

242: -- Cursor to get primary balance id value based on shadow element id
243:
244: CURSOR get_primary_balance_id (cp_element_id NUMBER) IS
245: SELECT fnd_number.number_to_canonical(pbt.balance_type_id)
246: FROM pay_balance_types pbt,
247: pay_element_types_f pet
248: WHERE pet.element_type_id = cp_element_id
249: AND pbt.balance_name = pet.element_name
250: AND pbt.business_group_id = pet.business_group_id;

Line 256: FROM pay_balance_types pbt,

252: -- Cursor to get hourly balance id value based on shadow element id
253:
254: CURSOR get_hourly_balance_id (cp_element_id NUMBER) IS
255: SELECT fnd_number.number_to_canonical(pbt.balance_type_id)
256: FROM pay_balance_types pbt,
257: pay_element_types_f pet
258: WHERE pet.element_type_id = cp_element_id
259: AND pbt.balance_name = pet.element_name||' Hours'
260: AND pbt.business_group_id = pet.business_group_id;

Line 266: FROM pay_balance_types pbt,

262: -- Cursor to get arrears balance id value based on shadow element id
263:
264: CURSOR get_arrears_balance_id (cp_element_id NUMBER) IS
265: SELECT fnd_number.number_to_canonical(pbt.balance_type_id)
266: FROM pay_balance_types pbt,
267: pay_element_types_f pet
268: WHERE pet.element_type_id = cp_element_id
269: AND pbt.balance_name = pet.element_name||' Arrears'
270: AND pbt.business_group_id = pet.business_group_id;

Line 276: FROM pay_balance_types pbt,

272: -- Cursor to get accruals balance id value based on shadow element id
273:
274: CURSOR get_accruals_balance_id (cp_element_id NUMBER) IS
275: SELECT fnd_number.number_to_canonical(pbt.balance_type_id)
276: FROM pay_balance_types pbt,
277: pay_element_types_f pet
278: WHERE pet.element_type_id = cp_element_id
279: AND pbt.balance_name = pet.element_name||' Accrued'
280: AND pbt.business_group_id = pet.business_group_id;