APPS.AML_MONITOR_WF dependencies on PV_SELECTED_ATTR_VALUES

Line 103: pv_selected_attr_values c,

99: -- ------------------------------------------------------------
100: SELECT DISTINCT a.process_rule_id, d.monitor_condition_id, d.time_lag_num
101: FROM pv_process_rules_b a,
102: pv_enty_select_criteria b,
103: pv_selected_attr_values c,
104: AML_monitor_conditions d
105: WHERE b.selection_type_code = 'MONITOR_SCOPE'
106: AND b.attribute_id = pv_check_match_pub.g_a_Country_
107: AND a.process_type = 'LEAD_MONITOR'

Line 122: pv_selected_attr_values c,

118: UNION ALL
119: SELECT DISTINCT a.process_rule_id, d.monitor_condition_id, d.time_lag_num
120: FROM pv_process_rules_b a,
121: pv_enty_select_criteria b,
122: pv_selected_attr_values c,
123: AML_monitor_conditions d
124: WHERE b.selection_type_code = 'MONITOR_SCOPE'
125: AND b.attribute_id =pv_check_match_pub.g_a_Lead_Rating
126: AND a.process_type = 'LEAD_MONITOR'

Line 2831: pv_selected_attr_values c,

2827: -- ------------------------------------------------------------
2828: SELECT DISTINCT a.process_rule_id, d.monitor_condition_id, d.time_lag_num
2829: FROM pv_process_rules_b a,
2830: pv_enty_select_criteria b,
2831: pv_selected_attr_values c,
2832: AML_monitor_conditions d
2833: WHERE b.selection_type_code = 'MONITOR_SCOPE'
2834: AND b.attribute_id = pv_check_match_pub.g_a_Country_
2835: AND a.process_type = 'LEAD_MONITOR'

Line 2849: pv_selected_attr_values c,

2845: INTERSECT
2846: SELECT DISTINCT a.process_rule_id, d.monitor_condition_id, d.time_lag_num
2847: FROM pv_process_rules_b a,
2848: pv_enty_select_criteria b,
2849: pv_selected_attr_values c,
2850: AML_monitor_conditions d
2851: WHERE b.selection_type_code = 'MONITOR_SCOPE'
2852: AND b.attribute_id =pv_check_match_pub.g_a_Lead_Rating
2853: AND a.process_type = 'LEAD_MONITOR'