APPS.CSTPAPPR dependencies on DUAL

Line 3950: from dual;

3946:
3947: select
3948: nvl(i_ae_curr_rec.alt_currency,i_ae_curr_rec.pri_currency)
3949: into l_ae_line_tbl(next_record_avail).currency_code
3950: from dual;
3951:
3952: l_stmt_num := 40;
3953: select
3954: decode(i_ae_curr_rec.alt_currency,

Line 3958: from dual;

3954: decode(i_ae_curr_rec.alt_currency,
3955: i_ae_curr_rec.pri_currency,NULL,
3956: i_ae_curr_rec.currency_conv_date)
3957: into l_ae_line_tbl(next_record_avail).currency_conv_date
3958: from dual;
3959:
3960: l_stmt_num := 50;
3961: select
3962: decode(i_ae_curr_rec.alt_currency,

Line 3966: from dual;

3962: decode(i_ae_curr_rec.alt_currency,
3963: i_ae_curr_rec.pri_currency,1,
3964: decode(i_ae_curr_rec.currency_conv_rate,-1,1,i_ae_curr_rec.currency_conv_rate))
3965: into l_ae_line_tbl(next_record_avail).currency_conv_rate
3966: from dual;
3967:
3968: l_stmt_num := 60;
3969: select
3970: decode(i_ae_curr_rec.alt_currency,

Line 3974: from dual;

3970: decode(i_ae_curr_rec.alt_currency,
3971: i_ae_curr_rec.pri_currency,NULL,
3972: i_ae_curr_rec.currency_conv_type)
3973: into l_ae_line_tbl(next_record_avail).currency_conv_type
3974: from dual;
3975:
3976:
3977: l_stmt_num := 70;
3978: