APPS.IEC_REPORTCLEAN_PVT dependencies on IEC_REP_CPN_DIAL_STATS

Line 11: delete from iec_rep_cpn_dial_stats where campaign_schedule_id = P_SCHEDULE_ID;

7: )
8: AS
9: l_count NUMBER := 0;
10: BEGIN
11: delete from iec_rep_cpn_dial_stats where campaign_schedule_id = P_SCHEDULE_ID;
12: delete from iec_rep_agent_status where campaign_schedule_id = P_SCHEDULE_ID;
13: delete from iec_rep_campaign_details where campaign_schedule_id = P_SCHEDULE_ID;
14: delete from iec_rep_agent_cpn_details where campaign_schedule_id = P_SCHEDULE_ID;
15:

Line 44: delete from iec_rep_cpn_dial_stats;

40: PROCEDURE CLEANUP
41: AS
42: l_count NUMBER := 0;
43: BEGIN
44: delete from iec_rep_cpn_dial_stats;
45: delete from iec_rep_agent_status;
46: delete from iec_rep_campaign_details;
47: delete from iec_rep_agent_cpn_details;
48: update iec_g_cpn_schedule_reset set last_update_date = sysdate;