APPS.PV_PROCESS_RULE_PVT dependencies on PV_PROCESS_RULES_VL

Line 618: from pv_process_rules_vl

614: -- ------------------------------------------------------------------------
615: /*
616: cursor lc_retrieve_rule_components(pc_rule_id number) is
617: select parent_rule_id, process_type
618: from pv_process_rules_vl
619: where process_rule_id = pc_rule_id;
620: */
621:
622: -- ------------------------------------------------------------------------

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 646: FROM pv_process_rules_vl a

642: and a.process_rule_id = b.process_rule_id;
643: ------------------------------------------------------- */
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:

Line 653: FROM pv_process_rules_vl a

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
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:

Line 676: from pv_process_rules_vl

672: where process_rule_id = pc_rule_id;
673:
674: cursor lc_get_parent_rule_id (pc_rule_id number) is
675: select process_rule_id
676: from pv_process_rules_vl
677: where parent_rule_id = pc_rule_id;
678:
679:
680: l_ENTYROUT_rec PV_RULE_RECTYPE_PUB.ENTYROUT_Rec_Type;

Line 733: FROM pv_process_rules_vl

729: -- Find out if the current rule is a main rule or a subrule.
730: -- ------------------------------------------------------------------
731: FOR x IN (
732: SELECT parent_rule_id, process_type
733: FROM pv_process_rules_vl
734: WHERE process_rule_id = p_PROCESS_RULE_rec.PROCESS_RULE_ID)
735: LOOP
736: IF (x.parent_rule_id IS NOT NULL) THEN
737: l_is_main_rule_flag := FALSE;

Line 1575: FROM pv_process_rules_vl parent,

1571: cursor lc_chk_criterion_dups (pc_parent_rule_id number,
1572: pc_child_rule_id number,
1573: pc_rank number) is
1574: SELECT child.rank
1575: FROM pv_process_rules_vl parent,
1576: pv_process_rules_vl child
1577: WHERE parent.process_rule_id = pc_parent_rule_id AND
1578: parent.process_rule_id = child.parent_rule_id AND
1579: child.process_rule_id <> NVL(pc_child_rule_id, 0) AND

Line 1576: pv_process_rules_vl child

1572: pc_child_rule_id number,
1573: pc_rank number) is
1574: SELECT child.rank
1575: FROM pv_process_rules_vl parent,
1576: pv_process_rules_vl child
1577: WHERE parent.process_rule_id = pc_parent_rule_id AND
1578: parent.process_rule_id = child.parent_rule_id AND
1579: child.process_rule_id <> NVL(pc_child_rule_id, 0) AND
1580: child.rank = pc_rank;