APPS.FND_OAM_KBF_SUBS dependencies on V$PARAMETER

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

278: and fltc.transaction_context_id = flm.transaction_context_id
279: and fltc.component_appl_id = fa.application_id (+);
280:
281: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
282: select VALUE into l_system from V$PARAMETER where NAME='db_name';
283:
284: fdebug('l_app_id=' || l_app_id);
285: fdebug('l_app_sn=' || l_app_sn);
286: fdebug('l_comp_type=' || l_comp_type);

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

518: and fl.lookup_type = 'FND_KBF_SEVERITY'
519: and flm.log_sequence = document_id;
520:
521: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
522: select VALUE into l_system from V$PARAMETER where NAME='db_name';
523:
524: FND_MESSAGE.CLEAR;
525: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
526: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);