APPS.PAY_MX_RULES dependencies on PAY_ELEMENT_TYPES_F

Line 334: FROM pay_element_types_f

330:
331: CURSOR get_element_type_id( cp_business_group_id NUMBER
332: ,cp_element_name VARCHAR2 ) IS
333: SELECT element_type_id
334: FROM pay_element_types_f
335: WHERE business_group_id = cp_business_group_id
336: AND element_name = cp_element_name;
337:
338: /*CURSOR get_core_element_type_id (cp_template_id NUMBER,

Line 402: UPDATE pay_element_types_f

398: lv_context := lv_legislation_code || '_' || upper(lv_classification_name);
399:
400: IF l_tmplt.template_name = 'Days X Rate' THEN
401:
402: UPDATE pay_element_types_f
403: SET element_information_category = lv_context
404: ,element_information1 = l_tmplt.preference_information8
405: WHERE element_type_id = ln_element_type_id;
406:

Line 409: UPDATE pay_element_types_f

405: WHERE element_type_id = ln_element_type_id;
406:
407: ELSIF instr( l_tmplt.template_name, 'Deduction' ) > 0 THEN
408:
409: UPDATE pay_element_types_f
410: SET element_information_category = lv_context
411: ,element_information1 = l_tmplt.configuration_information1
412: WHERE element_type_id = ln_element_type_id;
413:

Line 533: UPDATE pay_element_types_f

529:
530: IF lv_sub_classification_name IN
531: ('Supplemental Earnings:Social Foresight Earnings',
532: 'Imputed Earnings:Social Foresight Earnings') THEN
533: UPDATE pay_element_types_f
534: SET processing_priority = 4490
535: WHERE element_type_id = ln_element_type_id;
536: EXIT;
537: END IF;

Line 541: UPDATE pay_element_types_f

537: END IF;
538:
539: IF lv_sub_classification_name =
540: 'Employer Contribution to Savings Fund' THEN
541: UPDATE pay_element_types_f
542: SET processing_priority = 4480
543: WHERE element_type_id = ln_element_type_id;
544: EXIT;
545: END IF;