APPS.PAY_ELEMENT_TEMPLATE_USER_INIT dependencies on PAY_ELEMENT_TYPES_F

Line 236: FROM pay_element_types_f pet,

232: CURSOR get_element_type_id (cp_element_name VARCHAR2,
233: cp_business_grp_id NUMBER) IS
234: SELECT pet.element_type_id,
235: upper(pec.classification_name)
236: FROM pay_element_types_f pet,
237: pay_element_classifications pec
238: WHERE pet.element_name = cp_element_name
239: AND pet.business_group_id = cp_business_grp_id
240: AND pec.classification_id = pet.classification_id;

Line 247: pay_element_types_f pet

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

Line 257: pay_element_types_f pet

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

Line 267: pay_element_types_f pet

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

Line 277: pay_element_types_f pet

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;
281:

Line 713: UPDATE pay_element_types_f set ELEMENT_INFORMATION10 = lv_primary_bal_id , ELEMENT_INFORMATION12 = lv_hourly_bal_id, ELEMENT_INFORMATION11 = lv_arrears_bal_id, ELEMENT_INFORMATION13 = lv_accruals_bal_id

709: CLOSE get_accruals_balance_id;
710:
711: END IF;
712:
713: UPDATE pay_element_types_f set ELEMENT_INFORMATION10 = lv_primary_bal_id , ELEMENT_INFORMATION12 = lv_hourly_bal_id, ELEMENT_INFORMATION11 = lv_arrears_bal_id, ELEMENT_INFORMATION13 = lv_accruals_bal_id
714: WHERE element_type_id = ln_element_type_id
715: AND element_information_category = upper(l_rec.legislation_code)||'_'||lv_classification_name;
716: COMMIT;
717: