APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_CLIENT_NFN_LOG_ACC

Line 460: FOR nfn_rec IN (SELECT NOTIFICATION_ID,USER_ID FROM csm_client_nfn_log_acc acc

456: END LOOP;
457:
458: DELETE FROM csm_auto_sync_nfn WHERE CREATION_DATE < SYSDATE-l_days;
459:
460: FOR nfn_rec IN (SELECT NOTIFICATION_ID,USER_ID FROM csm_client_nfn_log_acc acc
461: WHERE NOT EXISTS (SELECT 1 FROM csm_auto_sync_nfn b
462: WHERE b.NOTIFICATION_ID=acc.NOTIFICATION_ID))
463: LOOP
464: CSM_ACC_PKG.Delete_Acc

Line 466: ,P_ACC_TABLE_NAME => 'CSM_CLIENT_NFN_LOG_ACC'

462: WHERE b.NOTIFICATION_ID=acc.NOTIFICATION_ID))
463: LOOP
464: CSM_ACC_PKG.Delete_Acc
465: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG')
466: ,P_ACC_TABLE_NAME => 'CSM_CLIENT_NFN_LOG_ACC'
467: ,P_PK1_NAME => 'NOTIFICATION_ID'
468: ,P_PK1_NUM_VALUE => nfn_rec.NOTIFICATION_ID
469: ,P_USER_ID => nfn_rec.USER_ID
470: );