DBA Data[Home] [Help]

APPS.AML_LEAD_DEDUPE_PVT dependencies on PV_ENTY_SELECT_CRITERIA

Line 95: FROM pv_enty_select_criteria ruleattr, pv_attributes_vl attr

91: -- Query to get all matching attributes in dedupe rule
92: CURSOR c_get_matching_attr
93: IS
94: SELECT ruleattr.attribute_id, attr.NAME
95: FROM pv_enty_select_criteria ruleattr, pv_attributes_vl attr
96: WHERE ruleattr.process_rule_id = 60
97: AND ruleattr.attribute_id = attr.attribute_id
98: AND ruleattr.selection_type_code = 'CRITERION';
99: BEGIN

Line 270: FROM pv_enty_select_criteria ruleattr,

266: IS
267: CURSOR C_get_created_within_days
268: IS
269: SELECT attrvals.attribute_value
270: FROM pv_enty_select_criteria ruleattr,
271: pv_selected_attr_values attrvals
272: WHERE ruleattr.process_rule_id = 60
273: AND ruleattr.selection_type_code = 'INPUT_FILTER'
274: AND ruleattr.selection_criteria_id = attrvals.selection_criteria_id;