APPS.PAY_ELEMENT_TEMPLATE_USER_INIT dependencies on FND_NUMBER

Line 245: SELECT fnd_number.number_to_canonical(pbt.balance_type_id)

241:
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

Line 255: SELECT fnd_number.number_to_canonical(pbt.balance_type_id)

251:
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'

Line 265: SELECT fnd_number.number_to_canonical(pbt.balance_type_id)

261:
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'

Line 275: SELECT fnd_number.number_to_canonical(pbt.balance_type_id)

271:
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'