APPS.AML_INTERACTION_ENGINE dependencies on AML_INTERACTION_LEADS

Line 454: FROM aml_interaction_leads il

450: ORDER BY imp.interaction_score DESC, imp.creation_date DESC;
451:
452: CURSOR C_Find_Highest_Score(c_import_interface_id NUMBER) IS
453: SELECT il.score
454: FROM aml_interaction_leads il
455: WHERE il.import_interface_id = c_import_interface_id
456: ORDER BY il.score desc;
457:
458: CURSOR C_Get_Run_Import_Flag(c_batch_id NUMBER) IS

Line 764: AML_INTERACTION_LEADS_PKG.INSERT_ROW(

760: END IF; -- lead get reprocessed
761:
762: -- Maintain relevance of interaction and lead
763: l_INTERACTION_LEAD_ID := NULL;
764: AML_INTERACTION_LEADS_PKG.INSERT_ROW(
765: px_INTERACTION_LEAD_ID => l_INTERACTION_LEAD_ID,
766: p_INTERACTION_ID => l_interaction_id_tbl(i),
767: p_IMPORT_INTERFACE_ID => NULL,
768: p_SALES_LEAD_ID => l_sales_lead_id,

Line 901: AML_INTERACTION_LEADS_PKG.INSERT_ROW(

897: CLOSE C_Get_Category;
898:
899: -- Maintain relevance of interaction and response
900: l_INTERACTION_LEAD_ID := NULL;
901: AML_INTERACTION_LEADS_PKG.INSERT_ROW(
902: px_INTERACTION_LEAD_ID => l_INTERACTION_LEAD_ID,
903: p_INTERACTION_ID => l_interaction_id_tbl(i),
904: p_IMPORT_INTERFACE_ID => l_import_interface_id,
905: p_SALES_LEAD_ID => NULL,