DBA Data[Home] [Help]

APPS.OKL_LCKBX_CSH_APP_PVT dependencies on DUAL

Line 1281: from dual;

1277: 3,l_currency_code3,4,l_currency_code4,
1278: 5,l_currency_code5,6,l_currency_code6,
1279: 7,l_currency_code7,8,l_currency_code8)
1280: into l_tmp_amount_applied, l_tmp_amount_app_from, l_tmp_currency_code
1281: from dual;
1282:
1283:
1284: IF l_orig_rcpt_tbl(i).invoice_number IS NOT NULL AND ( l_tmp_amount_applied IS NOT NULL OR l_tmp_amount_app_from IS NOT NULL)
1285: AND ( l_tmp_amount_applied <> 0 OR l_tmp_amount_app_from <> 0 ) THEN

Line 1955: FROM DUAL;

1951: l_new_trans_to_rct_rate8 := l_okl_rcpt_tbl (k).inv_hdr_rec.trans_to_receipt_rate;
1952:
1953: SELECT ar_payments_interface_s.NEXTVAL
1954: INTO l_transmission_rec_id_of
1955: FROM DUAL;
1956:
1957: log_debug
1958: ('Inserting overflow record with application information for the current payment record'
1959: );

Line 2518: from dual;

2514: 3,l_currency_code3,4,l_currency_code4,
2515: 5,l_currency_code5,6,l_currency_code6,
2516: 7,l_currency_code7,8,l_currency_code8)
2517: into l_tmp_amount_applied, l_tmp_amount_app_from, l_tmp_currency_code
2518: from dual;
2519:
2520: IF l_orig_rcpt_tbl (i).invoice_number IS NOT NULL
2521: AND ( l_tmp_amount_applied IS NOT NULL OR l_tmp_amount_app_from IS NOT NULL)
2522: AND ( l_tmp_amount_applied <> 0 OR l_tmp_amount_app_from <> 0 ) THEN

Line 3192: FROM DUAL;

3188:
3189: -- create new overflow records
3190: SELECT ar_payments_interface_s.NEXTVAL
3191: INTO l_transmission_rec_id_of
3192: FROM DUAL;
3193:
3194: log_debug
3195: ('Inserting overflow record with application information for the current payment record'
3196: );