APPS.FND_OAM_KBF_SUBS dependencies on V$PARAMETER

Line 289: select VALUE into l_system from V$PARAMETER where NAME='db_name';

285: and fltc.transaction_context_id = flm.transaction_context_id
286: and fltc.component_appl_id = fa.application_id (+);
287:
288: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
289: select VALUE into l_system from V$PARAMETER where NAME='db_name';
290:
291: fdebug('l_app_id=' || l_app_id);
292: fdebug('l_app_sn=' || l_app_sn);
293: fdebug('l_comp_type=' || l_comp_type);

Line 529: select VALUE into l_system from V$PARAMETER where NAME='db_name';

525: and fl.lookup_type = 'FND_KBF_SEVERITY'
526: and flm.log_sequence = document_id;
527:
528: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
529: select VALUE into l_system from V$PARAMETER where NAME='db_name';
530:
531: FND_MESSAGE.CLEAR;
532: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
533: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);