460: AND pspr.element_type_id = c_element_type_id;
461:
462: /* Checks whether formula result rule exist for the element */
463: CURSOR c_get_formula_result_rules(c_element_type_id pay_element_types_f.element_type_id%type,
464: c_result_name pay_formula_result_rules_f.result_name%type,
465: c_result_rule_type pay_formula_result_rules_f.result_rule_type%type,
466: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
467: IS
468: select count(*)
461:
462: /* Checks whether formula result rule exist for the element */
463: CURSOR c_get_formula_result_rules(c_element_type_id pay_element_types_f.element_type_id%type,
464: c_result_name pay_formula_result_rules_f.result_name%type,
465: c_result_rule_type pay_formula_result_rules_f.result_rule_type%type,
466: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
467: IS
468: select count(*)
469: from pay_status_processing_rules_f pssp,
462: /* Checks whether formula result rule exist for the element */
463: CURSOR c_get_formula_result_rules(c_element_type_id pay_element_types_f.element_type_id%type,
464: c_result_name pay_formula_result_rules_f.result_name%type,
465: c_result_rule_type pay_formula_result_rules_f.result_rule_type%type,
466: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
467: IS
468: select count(*)
469: from pay_status_processing_rules_f pssp,
470: pay_formula_result_rules_f pfrr
466: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
467: IS
468: select count(*)
469: from pay_status_processing_rules_f pssp,
470: pay_formula_result_rules_f pfrr
471: where pssp.element_type_id = c_element_type_id
472: and pfrr.status_processing_rule_id = pssp.status_processing_rule_id
473: AND pfrr.result_name = c_result_name
474: AND pfrr.result_rule_type = c_result_rule_type