APPS.PV_OPP_MATCH_PUB dependencies on PV_ATTRIBUTES_VL

Line 895: pv_attributes_vl b

891: -- -------------------------------------------------------------------------
892: CURSOR lc_partner_mapping IS
893: SELECT a.source_attr_id, a.target_attr_id, a.operator, b.return_type
894: FROM pv_entity_attr_mappings a,
895: pv_attributes_vl b
896: WHERE a.target_attr_id = b.attribute_id AND
897: a.process_rule_id = p_process_rule_id AND
898: a.source_attr_type = 'LEAD' AND
899: --a.source_attr_type = 'OPPORTUNITY' AND

Line 912: pv_attributes_vl c

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
915: a.selection_type_code = 'PARTNER_SELECTION' AND
916: a.process_rule_id = p_process_rule_id

Line 2081: pv_attributes_vl b

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
2085: ORDER BY a.rank;