APPS.AML_INTERACTION_ENGINE dependencies on AML_BUSINESS_EVENT_TYPES_B

Line 187: aml_business_event_types_b bet, hz_party_sites site

183: TO_NUMBER(NULL) contact_party_id
184: FROM jtf_ih_interactions interact, hz_parties party,
185: jtf_ih_activities acv, pv_process_rules_b rule,
186: pv_enty_select_criteria cra, pv_selected_attr_values val,
187: aml_business_event_types_b bet, hz_party_sites site
188: WHERE interact.party_id = party.party_id
189: AND interact.handler_id <> 530 -- for Oracle Marketing
190: AND party.party_type IN ('PERSON', 'ORGANIZATION')
191: AND party.party_id = site.party_id(+)

Line 213: pv_selected_attr_values val, aml_business_event_types_b bet

209: rel.subject_id contact_party_id
210: FROM jtf_ih_interactions interact, hz_parties party,
211: hz_relationships rel, hz_party_sites site, jtf_ih_activities acv,
212: pv_process_rules_b rule, pv_enty_select_criteria cra,
213: pv_selected_attr_values val, aml_business_event_types_b bet
214: WHERE interact.party_id = party.party_id
215: AND interact.handler_id <> 530 -- for Oracle Marketing
216: AND party.party_type = 'PARTY_RELATIONSHIP'
217: AND rel.object_id = site.party_id(+)

Line 328: pv_selected_attr_values val, aml_business_event_types_b bet

324:
325: CURSOR C_Calculate_Score(c_interaction_id NUMBER, c_process_rule_id NUMBER) IS
326: SELECT SUM(TO_NUMBER(val.score))
327: FROM jtf_ih_activities activity, pv_enty_select_criteria attr,
328: pv_selected_attr_values val, aml_business_event_types_b bet
329: WHERE activity.interaction_id = c_interaction_id
330: AND attr.process_rule_id = c_process_rule_id
331: AND attr.attribute_id = pv_check_match_pub.g_a_business_event_type
332: AND attr.selection_type_code = 'CRITERION'