APPS.AML_PURGE_SALES_LEADS dependencies on AS_SALES_LEAD_CONTACTS

Line 69: aml_debug(1,Recs_deleted(5)||l_no_of_rows_deleted||'AS_SALES_LEAD_CONTACTS');

65: aml_Debug(1,Recs_deleted(1)||l_no_of_rows_deleted||'AS_ACCESSES_ALL');
66: aml_debug(1,Recs_deleted(2)||l_no_of_rows_deleted||'AS_CHANGED_ACCOUNTS_ALL');
67: aml_debug(1,Recs_deleted(3)||l_no_of_rows_deleted||'AML_INTERACTION_LEADS');
68: aml_debug(1,Recs_deleted(4)||l_no_of_rows_deleted||'AS_SALES_LEADS_LOG');
69: aml_debug(1,Recs_deleted(5)||l_no_of_rows_deleted||'AS_SALES_LEAD_CONTACTS');
70: aml_debug(1,Recs_deleted(6)||l_no_of_rows_deleted||'AS_SALES_LEAD_LINES');
71: -- aml_debug(1,Recs_deleted(7)||l_no_of_rows_deleted||'AS_SALES_LEAD_OPPORTUNITY');
72: aml_debug(1,Recs_deleted(8)||l_no_of_rows_deleted||'AML_MONITOR_LOG');
73: aml_debug(1,Recs_deleted(9)||l_no_of_rows_deleted||'PV_ENTITY_RULES_APPLIED');

Line 108: FROM AS_SALES_LEAD_CONTACTS

104: Recs_deleted(4) := Recs_deleted(4) + SQL%ROWCOUNT;
105:
106: FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST
107: DELETE
108: FROM AS_SALES_LEAD_CONTACTS
109: WHERE Sales_Lead_Id = P_Id_Tab(I);
110: Recs_deleted(5) := Recs_deleted(5) + SQL%ROWCOUNT;
111:
112: FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST