DBA Data[Home] [Help]

APPS.PV_OPP_MATCH_PUB dependencies on PV_PROCESS_RULES_VL

Line 948: FROM pv_process_rules_vl

944: -- Cursor for retrieving the process rule name.
945: -- -------------------------------------------------------------------------
946: CURSOR lc_get_process_rule_name (p_process_rule_id IN NUMBER) IS
947: SELECT process_rule_name
948: FROM pv_process_rules_vl
949: WHERE process_rule_id = p_process_rule_id;
950:
951:
952: l_entity_routing lc_entity_routings%ROWTYPE;

Line 2562: FROM pv_process_rules_vl prr,

2558: pesc.operator,
2559: pesc.selection_criteria_id,
2560: psav.attribute_value,
2561: psav.attribute_to_value
2562: FROM pv_process_rules_vl prr,
2563: pv_enty_select_criteria pesc,
2564: pv_selected_attr_values psav
2565: WHERE prr.process_rule_id = pesc.process_rule_id AND
2566: pesc.selection_criteria_id = psav.selection_criteria_id (+) AND