APPS.FV_REIMB_ACTIVITY_PROCESS dependencies on DUAL

Line 815: SELECT REPLACE(g_select, 'glcc.', '') INTO l_select_mod FROM dual;

811: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'Incomplete Report Definition Setup',g_ERRBUF) ;
812: RAISE;
813: END;
814: -- Remove 'glcc.' from g_select
815: SELECT REPLACE(g_select, 'glcc.', '') INTO l_select_mod FROM dual;
816:
817: log(C_STATE_LEVEL, l_module, 'l_select_mod : '||l_select_mod);
818: log(C_STATE_LEVEL, l_module, 'l_column_id : '||l_column_id);
819:

Line 828: SELECT substr(l_select_mod,1, instr(l_select_mod, ' , ')) INTO l_temp_segnumber FROM dual;

824: -- If l_select_mod = SEGMENT1 , SEGMENT13 , SEGMENT15 THEN
825: -- gt_seg_codes(1) = SEGMENT1 , gt_seg_codes(13) = SEGMENT13 , gt_seg_codes(15) = SEGMENT15
826: --
827: WHILE LENGTH(l_select_mod)>9 LOOP
828: SELECT substr(l_select_mod,1, instr(l_select_mod, ' , ')) INTO l_temp_segnumber FROM dual;
829: gt_seg_codes((to_number((substr(l_temp_segnumber,8))))) := l_temp_segnumber;
830: SELECT substr(l_select_mod, instr(l_select_mod, ' , ')+3) INTO l_select_mod FROM dual;
831: END LOOP;
832: gt_seg_codes((to_number((substr(l_select_mod,8))))) := l_select_mod;

Line 830: SELECT substr(l_select_mod, instr(l_select_mod, ' , ')+3) INTO l_select_mod FROM dual;

826: --
827: WHILE LENGTH(l_select_mod)>9 LOOP
828: SELECT substr(l_select_mod,1, instr(l_select_mod, ' , ')) INTO l_temp_segnumber FROM dual;
829: gt_seg_codes((to_number((substr(l_temp_segnumber,8))))) := l_temp_segnumber;
830: SELECT substr(l_select_mod, instr(l_select_mod, ' , ')+3) INTO l_select_mod FROM dual;
831: END LOOP;
832: gt_seg_codes((to_number((substr(l_select_mod,8))))) := l_select_mod;
833:
834: FOR counter IN 1..30