DBA Data[Home] [Help]

APPS.FV_BE_INT_PKG dependencies on DUAL

Line 1347: FROM DUAL;

1343: IF ins_hdr THEN
1344:
1345: SELECT fv_be_trx_hdrs_s.nextval
1346: INTO new_doc_id
1347: FROM DUAL;
1348:
1349: SELECT treasury_symbol_id
1350: INTO v_ts_id
1351: FROM fv_fund_parameters

Line 1809: INTO v_amount FROM DUAL;

1805: );
1806:
1807: SELECT DECODE(valid_rec.increase_decrease_flag,'I',
1808: valid_rec.amount, (-1 * valid_rec.amount))
1809: INTO v_amount FROM DUAL;
1810:
1811: -- set the doc status to IMPORTING to identify which
1812: -- header records status should be changed to IN
1813: UPDATE fv_be_trx_hdrs

Line 2274: FROM DUAL;

2270: (l_doc_entry = 'M' AND l_doc_type = 'N')
2271: THEN
2272: SELECT to_number(v_doc_number)
2273: INTO l_doc_number
2274: FROM DUAL;
2275: END IF;
2276: EXCEPTION
2277: WHEN INVALID_NUMBER THEN
2278: v_error_code := -9;