APPS.PV_OPP_MATCH_PUB dependencies on PV_ENTY_SELECT_CRITERIA

Line 910: FROM pv_enty_select_criteria a,

906: SELECT a.attribute_id, a.operator,
907: b.attribute_value, b.attribute_to_value,
908: a.selection_criteria_id,
909: c.return_type
910: FROM pv_enty_select_criteria a,
911: pv_selected_attr_values b,
912: pv_attributes_vl c
913: WHERE a.attribute_id = c.attribute_id AND
914: a.selection_criteria_id = b.selection_criteria_id (+) AND

Line 2080: FROM pv_enty_select_criteria a,

2076: -- Fetch all the tie-breaking attributes for a matching rule.
2077: -- --------------------------------------------------------------------
2078: CURSOR c_tie_breaking_attr IS
2079: SELECT a.attribute_id, a.operator, b.return_type
2080: FROM pv_enty_select_criteria a,
2081: pv_attributes_vl b
2082: WHERE a.process_rule_id = p_process_rule_id AND
2083: UPPER(a.selection_type_code) = 'TIE_BREAKING' AND
2084: a.attribute_id = b.attribute_id

Line 2547: -- Note that we need an outer join from pv_enty_select_criteria to

2543: --| |
2544: --==============================================================================
2545: PROCEDURE Cache_Rules IS
2546: -- --------------------------------------------------------------------
2547: -- Note that we need an outer join from pv_enty_select_criteria to
2548: -- pv_selected_attr_value
2549: -- since certain attributes (e.g. is not null) will not
2550: -- have attribute values.
2551: -- --------------------------------------------------------------------

Line 2563: pv_enty_select_criteria pesc,

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
2567: prr.status_code = 'ACTIVE' AND