APPS.CSTPAPPR dependencies on DUAL

Line 3580: from dual;

3576:
3577: select
3578: nvl(i_ae_curr_rec.alt_currency,i_ae_curr_rec.pri_currency)
3579: into l_ae_line_tbl(next_record_avail).currency_code
3580: from dual;
3581:
3582: l_stmt_num := 40;
3583: select
3584: decode(i_ae_curr_rec.alt_currency,

Line 3588: from dual;

3584: decode(i_ae_curr_rec.alt_currency,
3585: i_ae_curr_rec.pri_currency,NULL,
3586: i_ae_curr_rec.currency_conv_date)
3587: into l_ae_line_tbl(next_record_avail).currency_conv_date
3588: from dual;
3589:
3590: l_stmt_num := 50;
3591: select
3592: decode(i_ae_curr_rec.alt_currency,

Line 3596: from dual;

3592: decode(i_ae_curr_rec.alt_currency,
3593: i_ae_curr_rec.pri_currency,1,
3594: decode(i_ae_curr_rec.currency_conv_rate,-1,1,i_ae_curr_rec.currency_conv_rate))
3595: into l_ae_line_tbl(next_record_avail).currency_conv_rate
3596: from dual;
3597:
3598: l_stmt_num := 60;
3599: select
3600: decode(i_ae_curr_rec.alt_currency,

Line 3604: from dual;

3600: decode(i_ae_curr_rec.alt_currency,
3601: i_ae_curr_rec.pri_currency,NULL,
3602: i_ae_curr_rec.currency_conv_type)
3603: into l_ae_line_tbl(next_record_avail).currency_conv_type
3604: from dual;
3605:
3606:
3607: l_stmt_num := 70;
3608: