DBA Data[Home] [Help]

APPS.FV_BE_INT_PKG dependencies on DUAL

Line 1275: FROM DUAL;

1271: IF ins_hdr THEN
1272:
1273: SELECT fv_be_trx_hdrs_s.nextval
1274: INTO new_doc_id
1275: FROM DUAL;
1276:
1277: SELECT treasury_symbol_id
1278: INTO v_ts_id
1279: FROM fv_fund_parameters

Line 1727: INTO v_amount FROM DUAL;

1723: );
1724:
1725: SELECT DECODE(valid_rec.increase_decrease_flag,'I',
1726: valid_rec.amount, (-1 * valid_rec.amount))
1727: INTO v_amount FROM DUAL;
1728:
1729: -- set the doc status to IMPORTING to identify which
1730: -- header records status should be changed to IN
1731: UPDATE fv_be_trx_hdrs

Line 2183: FROM DUAL;

2179: (l_doc_entry = 'M' AND l_doc_type = 'N')
2180: THEN
2181: SELECT to_number(v_doc_number)
2182: INTO l_doc_number
2183: FROM DUAL;
2184: END IF;
2185: EXCEPTION
2186: WHEN INVALID_NUMBER THEN
2187: v_error_code := -9;