APPS.AML_PURGE_IMPORT_INTERFACE dependencies on AML_INTERACTION_LEADS

Line 55: write_log(1,Recs_deleted(6)||l_no_of_rows_deleted||'AML_INTERACTION_LEADS');

51: write_log(1,Recs_deleted(2)||l_no_of_rows_deleted||'AS_IMP_SL_FLEX');
52: write_log(1,Recs_deleted(3)||l_no_of_rows_deleted||'AS_IMP_CNT_ROL_INTERFACE');
53: write_log(1,Recs_deleted(4)||l_no_of_rows_deleted||'AS_IMP_CNT_PNT_INTERFACE');
54: write_log(1,Recs_deleted(5)||l_no_of_rows_deleted||'AS_IMP_LINES_INTERFACE');
55: write_log(1,Recs_deleted(6)||l_no_of_rows_deleted||'AML_INTERACTION_LEADS');
56: -- write_log(1,Recs_deleted(7)||l_no_of_rows_deleted||'PV_ENTITY_RULES_APPLIED');
57: write_log(1,Recs_deleted(8)||l_no_of_rows_deleted||'AS_IMPORT_INTERFACE');
58: END write_count;
59:

Line 101: FROM AML_INTERACTION_LEADS

97:
98: -- Interaction table
99: FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST
100: DELETE
101: FROM AML_INTERACTION_LEADS
102: WHERE import_interface_id = P_Id_Tab(I);
103: Recs_deleted(6) := Recs_deleted(6) + SQL%ROWCOUNT;
104:
105: /* --PV Entity rules applied