[Home] [Help]
761: -- -------------------------------------------------------------------------
762: CURSOR lc_partner_mapping IS
763: SELECT a.source_attr_id, a.target_attr_id, a.operator, b.return_type
764: FROM pv_entity_attr_mappings a,
765: pv_attributes_vl b
766: WHERE a.target_attr_id = b.attribute_id AND
767: a.process_rule_id = p_process_rule_id AND
768: a.source_attr_type = 'LEAD' AND
769: --a.source_attr_type = 'OPPORTUNITY' AND
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
785: a.selection_type_code = 'PARTNER_SELECTION' AND
786: a.process_rule_id = p_process_rule_id
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
2505: ORDER BY a.rank;
3181:
3182: l_get_metric_raw_value varchar2(500) :=
3183:
3184: 'SELECT pav.return_type, pav.display_style, psav.attr_value,psav.attr_text, pav.decimal_points ' ||
3185: 'FROM pv_attributes_vl pav, ' ||
3186: ' pv_search_attr_values psav ' ||
3187: 'WHERE psav.PARTY_ID = :1 ' ||
3188: 'AND psav.attribute_id = :2 ' ||
3189: 'AND psav.attribute_id = pav.attribute_id ' ;
3249:
3250: l_get_metric_raw_value varchar2(500) :=
3251:
3252: 'SELECT pav.return_type, pav.display_style, psav.attr_value,psav.attr_text, pav.decimal_points ' ||
3253: 'FROM pv_attributes_vl pav, ' ||
3254: ' pv_search_attr_values psav ' ||
3255: 'WHERE psav.PARTY_ID = :1 ' ||
3256: 'AND psav.attribute_id = :2 ' ||
3257: 'AND psav.attribute_id = pav.attribute_id ' ;