APPS.AML_PURGE_SALES_LEADS dependencies on AS_CHANGED_ACCOUNTS_ALL

Line 66: aml_debug(1,Recs_deleted(2)||l_no_of_rows_deleted||'AS_CHANGED_ACCOUNTS_ALL');

62: PROCEDURE write_count IS
63: l_no_of_rows_deleted CONSTANT varchar2(100) := ' rows deleted from the table ';
64: BEGIN
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');

Line 90: FROM AS_CHANGED_ACCOUNTS_ALL

86: Recs_deleted(1) := Recs_deleted(1) + SQL%ROWCOUNT;
87:
88: FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST
89: DELETE
90: FROM AS_CHANGED_ACCOUNTS_ALL
91: WHERE Sales_Lead_Id = P_Id_Tab(I);
92: Recs_deleted(2) := Recs_deleted(2) + SQL%ROWCOUNT;
93:
94: FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST