433: AND pspr.element_type_id = c_element_type_id;
434:
435: /* Checks whether formula result rule exist for the element */
436: CURSOR c_get_formula_result_rules(c_element_type_id pay_element_types_f.element_type_id%type,
437: c_result_name pay_formula_result_rules_f.result_name%type,
438: c_result_rule_type pay_formula_result_rules_f.result_rule_type%type,
439: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
440: IS
441: select count(*)
434:
435: /* Checks whether formula result rule exist for the element */
436: CURSOR c_get_formula_result_rules(c_element_type_id pay_element_types_f.element_type_id%type,
437: c_result_name pay_formula_result_rules_f.result_name%type,
438: c_result_rule_type pay_formula_result_rules_f.result_rule_type%type,
439: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
440: IS
441: select count(*)
442: from pay_status_processing_rules_f pssp,
435: /* Checks whether formula result rule exist for the element */
436: CURSOR c_get_formula_result_rules(c_element_type_id pay_element_types_f.element_type_id%type,
437: c_result_name pay_formula_result_rules_f.result_name%type,
438: c_result_rule_type pay_formula_result_rules_f.result_rule_type%type,
439: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
440: IS
441: select count(*)
442: from pay_status_processing_rules_f pssp,
443: pay_formula_result_rules_f pfrr
439: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
440: IS
441: select count(*)
442: from pay_status_processing_rules_f pssp,
443: pay_formula_result_rules_f pfrr
444: where pssp.element_type_id = c_element_type_id
445: and pfrr.status_processing_rule_id = pssp.status_processing_rule_id
446: AND pfrr.result_name = c_result_name
447: AND pfrr.result_rule_type = c_result_rule_type