APPS.FV_YE_CLOSE dependencies on DUAL

Line 1399: FROM DUAL;

1395: -- Process all expired records first and then Cancelled records
1396: FOR i IN 1..2 LOOP
1397: SELECT DECODE(i,1,'Expired',2,'Canceled')
1398: INTO vg_acct_flag
1399: FROM DUAL;
1400: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1401: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' VG_ACCT_FLAG '||VG_ACCT_FLAG);
1402: END IF;
1403:

Line 1414: FROM DUAL;

1410: END LOOP;
1411: ELSE
1412: SELECT DECODE(vl_status_flag,'E','Expired','C','Canceled','U','Unexpired')
1413: INTO vg_acct_flag
1414: FROM DUAL;
1415: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' VG_ACCT_FLAG '||VG_ACCT_FLAG);
1417: END IF;
1418:

Line 2356: FROM DUAL;

2352:
2353: BEGIN
2354: SELECT DECODE(i,1,vl_dbt_flag,vl_crt_flag)
2355: INTO vl_drcr_flag
2356: FROM DUAL;
2357:
2358: SELECT DECODE(i,1,vg_balance_read_flag,'N')
2359: INTO vl_read_flag
2360: FROM DUAL;

Line 2360: FROM DUAL;

2356: FROM DUAL;
2357:
2358: SELECT DECODE(i,1,vg_balance_read_flag,'N')
2359: INTO vl_read_flag
2360: FROM DUAL;
2361:
2362: EXCEPTION
2363: WHEN OTHERS THEN
2364: vp_retcode := 2 ;

Line 2666: FROM DUAL;

2662: -- Get the period net dr, period net cr
2663: BEGIN
2664: SELECT DECODE(dr_cr,'D',ABS(bal_amt),0)
2665: INTO vl_period_dr
2666: FROM DUAL;
2667:
2668: SELECT DECODE(dr_cr,'D',0,ABS(bal_amt))
2669: INTO vl_period_cr
2670: FROM DUAL;

Line 2670: FROM DUAL;

2666: FROM DUAL;
2667:
2668: SELECT DECODE(dr_cr,'D',0,ABS(bal_amt))
2669: INTO vl_period_cr
2670: FROM DUAL;
2671: EXCEPTION
2672: WHEN OTHERS THEN
2673: vp_retcode := 2 ;
2674: vp_errbuf := SQLERRM ||' -- Error in Insert_Balances procedure,'||

Line 2697: FROM DUAL;

2693: -- Get the report sequence
2694: BEGIN
2695: SELECT Fv_Ye_Seq_Bal_Temp_S.NEXTVAL
2696: INTO vl_report_seq
2697: FROM DUAL;
2698: EXCEPTION
2699: WHEN OTHERS THEN
2700: vp_retcode := 2 ;
2701: vp_errbuf := SQLERRM ||' -- Error in Determine_DrCr procedure,'||

Line 3187: FROM DUAL;

3183:
3184: -- Get the journal group_id
3185: SELECT Gl_Interface_Control_S.NEXTVAL
3186: INTO vg_jrnl_group_id
3187: FROM DUAL;
3188:
3189: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3190: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' INTERFACE RUN ID: '||TO_CHAR(VG_INTERFACE_RUN_ID));
3191: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' JOURNAL GROUP ID: '||TO_CHAR(VG_JRNL_GROUP_ID));