DBA Data[Home] [Help]

APPS.PV_MATCH_V3_PUB dependencies on PV_SELECTED_ATTR_VALUES

Line 781: pv_selected_attr_values b,

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
785: a.selection_type_code = 'PARTNER_SELECTION' AND

Line 3669: pv_selected_attr_values psav

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
3673: TRUNC(SYSDATE) BETWEEN prr.start_date AND