DBA Data[Home] [Help]

APPS.PV_MATCH_V3_PUB dependencies on PV_PROCESS_RULES_VL

Line 818: FROM pv_process_rules_vl

814: -- Cursor for retrieving the process rule name.
815: -- -------------------------------------------------------------------------
816: CURSOR lc_get_process_rule_name (p_process_rule_id IN NUMBER) IS
817: SELECT process_rule_name
818: FROM pv_process_rules_vl
819: WHERE process_rule_id = p_process_rule_id;
820:
821: x_partner_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
822: x_distance_uom_returned VARCHAR2(30);

Line 3667: FROM pv_process_rules_vl prr,

3663: pesc.operator,
3664: pesc.selection_criteria_id,
3665: psav.attribute_value,
3666: psav.attribute_to_value
3667: FROM pv_process_rules_vl prr,
3668: pv_enty_select_criteria pesc,
3669: pv_selected_attr_values psav
3670: WHERE prr.process_rule_id = pesc.process_rule_id AND
3671: pesc.selection_criteria_id = psav.selection_criteria_id (+) AND