DBA Data[Home] [Help]

APPS.AML_MONITOR_WF dependencies on PV_PROCESS_RULES_B

Line 101: FROM pv_process_rules_b a,

97: -- ------------------------------------------------------------
98: -- Country
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'

Line 120: FROM pv_process_rules_b a,

116: -- ------------------------------------------------------------
117: -- INTERSECT
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'

Line 137: FROM pv_process_rules_b a,

133: ) rule
134: GROUP BY rule.process_rule_id, rule.monitor_condition_id,rule.time_lag_num
135: HAVING (rule.process_rule_id, COUNT(*)) IN (
136: SELECT a.process_rule_id, COUNT(*)
137: FROM pv_process_rules_b a,
138: pv_enty_select_criteria b
139: WHERE a.process_rule_id = b.process_rule_id AND
140: b.selection_type_code = 'MONITOR_SCOPE' AND
141: a.status_code = 'ACTIVE' AND

Line 769: /* FROM pv_process_rules_b rule, fnd_user usr, jtf_rs_resource_extns res */

765:
766: /* */
767: /* CURSOR c_monitor_owner (c_process_rule_id number) IS */
768: /* SELECT usr.user_name */
769: /* FROM pv_process_rules_b rule, fnd_user usr, jtf_rs_resource_extns res */
770: /* WHERE rule.process_rule_id = c_process_rule_id */
771: /* AND rule.owner_resource_id = res.resource_id */
772: /* and res.user_id = usr.user_id; */
773:

Line 2829: FROM pv_process_rules_b a,

2825: -- ------------------------------------------------------------
2826: -- Country
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'

Line 2847: FROM pv_process_rules_b a,

2843: -- Lead Rating
2844: -- ------------------------------------------------------------
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'

Line 2864: FROM pv_process_rules_b a,

2860: ) rule
2861: GROUP BY rule.process_rule_id, rule.monitor_condition_id,rule.time_lag_num
2862: HAVING (rule.process_rule_id) IN (
2863: SELECT a.process_rule_id
2864: FROM pv_process_rules_b a,
2865: pv_enty_select_criteria b
2866: WHERE a.process_rule_id = b.process_rule_id AND
2867: b.selection_type_code = 'MONITOR_SCOPE' AND
2868: a.status_code = 'ACTIVE' AND