APPS.PV_PROCESS_RULE_PVT dependencies on PV_ENTITY_RULES_APPLIED

Line 640: from pv_entity_rules_applied a, pv_process_rules_vl b

636:
637: /* ------------------------------------------------------
638: cursor lc_validate_rule_referenced(pc_rule_id number) is
639: select process_rule_name
640: from pv_entity_rules_applied a, pv_process_rules_vl b
641: where a.process_rule_id = pc_rule_id
642: and a.process_rule_id = b.process_rule_id;
643: ------------------------------------------------------- */
644: cursor lc_validate_rule_referenced1(pc_rule_id number) is

Line 648: EXISTS (SELECT 'x' FROM pv_entity_rules_applied b

644: cursor lc_validate_rule_referenced1(pc_rule_id number) is
645: SELECT process_rule_name
646: FROM pv_process_rules_vl a
647: WHERE process_rule_id = pc_rule_id AND
648: EXISTS (SELECT 'x' FROM pv_entity_rules_applied b
649: WHERE a.process_rule_id = b.process_rule_id);
650:
651: cursor lc_validate_rule_referenced2(pc_rule_id number) is
652: SELECT process_rule_name

Line 655: EXISTS (SELECT 'x' FROM pv_entity_rules_applied b

651: cursor lc_validate_rule_referenced2(pc_rule_id number) is
652: SELECT process_rule_name
653: FROM pv_process_rules_vl a
654: WHERE process_rule_id = pc_rule_id AND
655: EXISTS (SELECT 'x' FROM pv_entity_rules_applied b
656: WHERE b.parent_process_rule_id = a.process_rule_id);
657:
658:
659: cursor lc_get_selcrit (pc_rule_id number) is