APPS.PAY_MX_RULES dependencies on PAY_ELEMENT_TYPES_F

Line 315: FROM pay_element_types_f

311:
312: CURSOR get_element_type_id( cp_business_group_id NUMBER
313: ,cp_element_name VARCHAR2 ) IS
314: SELECT element_type_id
315: FROM pay_element_types_f
316: WHERE business_group_id = cp_business_group_id
317: AND element_name = cp_element_name;
318:
319: /*CURSOR get_core_element_type_id (cp_template_id NUMBER,

Line 383: UPDATE pay_element_types_f

379: lv_context := lv_legislation_code || '_' || upper(lv_classification_name);
380:
381: IF l_tmplt.template_name = 'Days X Rate' THEN
382:
383: UPDATE pay_element_types_f
384: SET element_information_category = lv_context
385: ,element_information1 = l_tmplt.preference_information8
386: WHERE element_type_id = ln_element_type_id;
387:

Line 390: UPDATE pay_element_types_f

386: WHERE element_type_id = ln_element_type_id;
387:
388: ELSIF instr( l_tmplt.template_name, 'Deduction' ) > 0 THEN
389:
390: UPDATE pay_element_types_f
391: SET element_information_category = lv_context
392: ,element_information1 = l_tmplt.configuration_information1
393: WHERE element_type_id = ln_element_type_id;
394:

Line 514: UPDATE pay_element_types_f

510:
511: IF lv_sub_classification_name IN
512: ('Supplemental Earnings:Social Foresight Earnings',
513: 'Imputed Earnings:Social Foresight Earnings') THEN
514: UPDATE pay_element_types_f
515: SET processing_priority = 4490
516: WHERE element_type_id = ln_element_type_id;
517: EXIT;
518: END IF;

Line 522: UPDATE pay_element_types_f

518: END IF;
519:
520: IF lv_sub_classification_name =
521: 'Employer Contribution to Savings Fund' THEN
522: UPDATE pay_element_types_f
523: SET processing_priority = 4480
524: WHERE element_type_id = ln_element_type_id;
525: EXIT;
526: END IF;