[Home] [Help]
566: pfrrf.severity_level,
567: pfrrf.element_type_id
568: from pay_status_processing_rules_f psprf,
569: pay_element_types_f petf,
570: pay_formula_result_rules_f pfrrf
571: where petf.element_type_id = cp_ele_type_id
572: and petf.business_group_id = cp_bg_grp_id
573: and psprf.element_type_id = petf.element_type_id
574: and pfrrf.status_processing_rule_id = psprf.status_processing_rule_id;
594:
595: /*
596: * Delete the formula result rules for the Old element.
597: */
598: delete from pay_formula_result_rules_f
599: where status_processing_rule_id in (select distinct status_processing_rule_id
600: from pay_status_processing_rules_f psprf,
601: pay_element_types_f petf
602: where petf.element_type_id = p_old_ele_type_id
975: /*
976: * Updates the New Calculator formula result rule so that the
977: * STOP_ENTY result goes to the 'Pay Value' of Old Base element
978: */
979: update pay_formula_result_rules_f
980: set element_type_id = l_ele_type_id,
981: input_value_id = l_inp_val_id
982: where status_processing_rule_id = l_stat_proc_rule_id
983: and result_name = 'STOP_ENTRY'
1003: instead of New Fees
1004: Using Status Processing Rule ID of New Calculator Element
1005: */
1006:
1007: update pay_formula_result_rules_f
1008: set element_type_id = l_old_fees_ele_type_id,
1009: input_value_id = l_old_fees_inp_val_id
1010: where status_processing_rule_id = l_stat_proc_rule_id
1011: and result_name = 'WH_FEE_AMT'
1053: /*
1054: * Delete the formula result rules associated with the New Base element
1055: */
1056: DELETE
1057: FROM pay_formula_result_rules_f
1058: WHERE status_processing_rule_id
1059: IN (SELECT status_processing_rule_id
1060: FROM pay_status_processing_rules_f psprf
1061: WHERE psprf.element_type_id = l_element_type_id );