APPS.IEC_REPORTCLEAN_PVT dependencies on IEC_REP_AGENT_STATUS

Line 12: delete from iec_rep_agent_status where campaign_schedule_id = P_SCHEDULE_ID;

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:
16: select count(*) into l_count from iec_g_cpn_schedule_reset where campaign_schedule_id = P_SCHEDULE_ID;

Line 45: delete from iec_rep_agent_status;

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;
49: END;