APPS.IEM_PP_QUEUE_PVT dependencies on IEM_RT_PP_QUEUE_DTLS

Line 132: INSERT INTO IEM_RT_PP_QUEUE_DTLS

128: if (p_attach_name_tbl.FIRST is not null) then
129:
130: FOR i in p_attach_name_tbl.FIRST..p_attach_name_tbl.LAST LOOP
131:
132: INSERT INTO IEM_RT_PP_QUEUE_DTLS
133: (
134: EMAIL_ID,
135: ATTACHMENT_NAME,
136: ATTACHMENT_SIZE,

Line 384: delete IEM_RT_PP_QUEUE_DTLS where email_id in

380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:
382: --begins here
383:
384: delete IEM_RT_PP_QUEUE_DTLS where email_id in
385: ( select email_id from iem_rt_pp_queues where flag = 'S'
386: and email_account_id=p_acct_id );
387:
388: delete IEM_RT_PP_QUEUES where flag = 'S' and email_account_id=p_acct_id ;