[Home] [Help]
573: pfrrf.severity_level,
574: pfrrf.element_type_id
575: from pay_status_processing_rules_f psprf,
576: pay_element_types_f petf,
577: pay_formula_result_rules_f pfrrf
578: where petf.element_type_id = cp_ele_type_id
579: and petf.business_group_id = cp_bg_grp_id
580: and psprf.element_type_id = petf.element_type_id
581: and pfrrf.status_processing_rule_id = psprf.status_processing_rule_id;
601:
602: /*
603: * Delete the formula result rules for the Old element.
604: */
605: delete from pay_formula_result_rules_f
606: where status_processing_rule_id in (select distinct status_processing_rule_id
607: from pay_status_processing_rules_f psprf,
608: pay_element_types_f petf
609: where petf.element_type_id = p_old_ele_type_id
982: /*
983: * Updates the New Calculator formula result rule so that the
984: * STOP_ENTY result goes to the 'Pay Value' of Old Base element
985: */
986: update pay_formula_result_rules_f
987: set element_type_id = l_ele_type_id,
988: input_value_id = l_inp_val_id
989: where status_processing_rule_id = l_stat_proc_rule_id
990: and result_name = 'STOP_ENTRY'
1010: instead of New Fees
1011: Using Status Processing Rule ID of New Calculator Element
1012: */
1013:
1014: update pay_formula_result_rules_f
1015: set element_type_id = l_old_fees_ele_type_id,
1016: input_value_id = l_old_fees_inp_val_id
1017: where status_processing_rule_id = l_stat_proc_rule_id
1018: and result_name = 'WH_FEE_AMT'
1060: /*
1061: * Delete the formula result rules associated with the New Base element
1062: */
1063: DELETE
1064: FROM pay_formula_result_rules_f
1065: WHERE status_processing_rule_id
1066: IN (SELECT status_processing_rule_id
1067: FROM pay_status_processing_rules_f psprf
1068: WHERE psprf.element_type_id = l_element_type_id );