APPS.PV_MATCH_V3_PUB dependencies on PV_ENTY_SELECT_CRITERIA

Line 780: FROM pv_enty_select_criteria a,

776: SELECT a.attribute_id, a.operator,
777: b.attribute_value, b.attribute_to_value,
778: a.selection_criteria_id,
779: c.return_type
780: FROM pv_enty_select_criteria a,
781: pv_selected_attr_values b,
782: pv_attributes_vl c
783: WHERE a.attribute_id = c.attribute_id AND
784: a.selection_criteria_id = b.selection_criteria_id (+) AND

Line 2500: FROM pv_enty_select_criteria a,

2496: -- Fetch all the tie-breaking attributes for a matching rule.
2497: -- --------------------------------------------------------------------
2498: CURSOR c_tie_breaking_attr IS
2499: SELECT a.attribute_id, a.operator, b.return_type
2500: FROM pv_enty_select_criteria a,
2501: pv_attributes_vl b
2502: WHERE a.process_rule_id = p_process_rule_id AND
2503: UPPER(a.selection_type_code) = 'TIE_BREAKING' AND
2504: a.attribute_id = b.attribute_id

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

3648: -- ===========================End of Get_Next_Rule_Index===========================
3649:
3650: PROCEDURE Cache_Rules IS
3651: -- --------------------------------------------------------------------
3652: -- Note that we need an outer join from pv_enty_select_criteria to
3653: -- pv_selected_attr_value
3654: -- since certain attributes (e.g. is not null) will not
3655: -- have attribute values.
3656: -- --------------------------------------------------------------------

Line 3668: pv_enty_select_criteria pesc,

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