APPS.AML_MONITOR_WF dependencies on AML_MONITOR_CONDITIONS

Line 104: AML_monitor_conditions d

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'
108: AND a.process_rule_id = b.process_rule_id

Line 123: AML_monitor_conditions d

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'
127: AND a.process_rule_id = b.process_rule_id

Line 741: FROM AML_monitor_conditions d

737: d.time_lag_num, d.time_lag_uom_code,
738: d.expiration_relative, d.Reminder_defined, d.total_reminders,
739: d.reminder_frequency,d.timeout_defined, d.timeout_duration,
740: d.timeout_uom_code, d.notify_owner, d.notify_owner_manager
741: FROM AML_monitor_conditions d
742: WHERE d.monitor_condition_id = c_monitor_condition_id;
743:
744: -- Get lead info
745: CURSOR c_get_lead_details (c_sales_lead_id NUMBER) IS

Line 2832: AML_monitor_conditions d

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'
2836: AND a.process_rule_id = b.process_rule_id

Line 2850: AML_monitor_conditions d

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'
2854: AND a.process_rule_id = b.process_rule_id