APPS.FND_OAM_KBF_SUBS dependencies on FND_OAM_BIZEX_SENT_NOTIF

Line 25: from FND_OAM_BIZEX_SENT_NOTIF

21: fdebug('pSubID:' || pSubID);
22: fdebug('pUniqueExId:' || pUniqueExId);
23:
24: select count(*) into l_count
25: from FND_OAM_BIZEX_SENT_NOTIF
26: where
27: UNIQUE_EXCEPTION_ID = pUniqueExId
28: and SUBSCRIPTION_ID = pSubID
29: ;

Line 416: insert into FND_OAM_BIZEX_SENT_NOTIF(UNIQUE_EXCEPTION_ID, SUBSCRIPTION_ID, SENT) values

412: l_sub_list := subs_record.role_id;
413: ELSE
414: l_sub_list := l_sub_list || ','|| subs_record.role_id;
415: END IF;
416: insert into FND_OAM_BIZEX_SENT_NOTIF(UNIQUE_EXCEPTION_ID, SUBSCRIPTION_ID, SENT) values
417: (l_unique_ex_id, subs_record.SUBSCRIPTION_ID, sysdate);
418:
419: ---fdebug('l_sub_list=' || l_sub_list);
420: