APPS.AML_MONITOR_WF dependencies on PV_CHECK_MATCH_PUB

Line 106: AND b.attribute_id = pv_check_match_pub.g_a_Country_

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
109: AND b.selection_criteria_id = c.selection_criteria_id(+)
110: AND (b.operator = 'EQUALS' AND c.attribute_value = c_country)

Line 125: AND b.attribute_id =pv_check_match_pub.g_a_Lead_Rating

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
128: AND b.selection_criteria_id = c.selection_criteria_id(+)
129: AND (b.operator = 'EQUALS' AND c.attribute_value = c_lead_rank )

Line 2834: AND b.attribute_id = pv_check_match_pub.g_a_Country_

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
2837: AND b.selection_criteria_id = c.selection_criteria_id(+)
2838: AND (b.operator = 'EQUALS' AND c.attribute_value = c_country)

Line 2852: AND b.attribute_id =pv_check_match_pub.g_a_Lead_Rating

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
2855: AND b.selection_criteria_id = c.selection_criteria_id(+)
2856: AND (b.operator = 'EQUALS' AND c.attribute_value = c_lead_rank )