APPS.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on DUAL

Line 387: FROM DUAL;

383: BEGIN
384: if g_curr_precision <= 0 then
385: SELECT TO_CHAR(round(num_amount,g_curr_precision))
386: INTO char_amount
387: FROM DUAL;
388: else
389: SELECT TO_CHAR(ROUND(num_amount,g_curr_precision))
390: INTO tmp_amnt
391: FROM DUAL;

Line 391: FROM DUAL;

387: FROM DUAL;
388: else
389: SELECT TO_CHAR(ROUND(num_amount,g_curr_precision))
390: INTO tmp_amnt
391: FROM DUAL;
392:
393: select rpad(tmp_amnt,
394: decode(sign(length(tmp_amnt)+g_curr_precision-(length(tmp_amnt) - instr(tmp_amnt,'.')))
395: ,-1,length(tmp_amnt)

Line 400: from dual;

396: ,0 ,length(tmp_amnt)
397: ,length(tmp_amnt) + g_curr_precision - (length(tmp_amnt) -
398: decode(instr(tmp_amnt,'.'),0,1,instr(tmp_amnt,'.')))),'0')
399: into char_amount
400: from dual;
401: end if;
402:
403:
404: END format_amount_out;

Line 420: FROM DUAL;

416: g_chart_of_accounts_id,
417: p_dist_ccid);
418: SELECT rpad(g_conc_segs,45,' ')
419: INTO g_conc_segs
420: FROM DUAL;
421:
422: END get_segs;
423:
424:

Line 1276: FROM sys.dual;

1272:
1273:
1274: SELECT gl_interface_control_s.nextval
1275: INTO l_group_id
1276: FROM sys.dual;
1277:
1278:
1279: FOR jes_lin_rec IN jes_lines
1280: LOOP