279: l_delete_flag VARCHAR2(1):='Y';
280:
281: cursor lc_check_rules (pc_attr_code_id number) is
282: select distinct seleted.attribute_value,rules.process_rule_name
283: from pv_enty_select_criteria criteria,pv_selected_attr_values seleted,
284: pv_process_rules_vl rules,pv_attribute_codes_vl code
285: where code.attr_code_id= pc_attr_code_id and
286: criteria.attribute_id= code.attribute_id and
287: criteria.selection_criteria_id= seleted.selection_criteria_id and
640:
641:
642: cursor lc_check_rules (pc_attr_code_id number) is
643: select distinct seleted.attribute_value,rules.process_rule_name
644: from pv_enty_select_criteria criteria,pv_selected_attr_values seleted,
645: pv_process_rules_vl rules,pv_attribute_codes_vl code
646: where code.attr_code_id= pc_attr_code_id and
647: criteria.attribute_id= code.attribute_id and
648: criteria.selection_criteria_id= seleted.selection_criteria_id and