APPS.FV_FACTS_TRANSACTIONS dependencies on FV_BE_TRX_DTLS

Line 2150: FROM fv_be_trx_dtls

2146:
2147: BEGIN
2148: SELECT public_law_code
2149: INTO va_public_law_code_val
2150: FROM fv_be_trx_dtls
2151: WHERE transaction_id = vl_legis_ref
2152: AND set_of_books_id = vp_set_of_books_id ;
2153:
2154: IF va_public_law_code_val is NULL THEN

Line 2249: FROM fv_be_trx_dtls

2245: -- Get the Transaction Type Value
2246: BEGIN
2247: SELECT transaction_type_id
2248: INTO vl_tran_type
2249: FROM fv_be_trx_dtls
2250: WHERE transaction_id = vl_legis_ref
2251: AND set_of_books_id = vp_set_of_books_id ;
2252: -- Get the Legislation Indicator Value
2253: -- from fv_be_transaction_types table.

Line 2329: FROM fv_be_trx_dtls

2325: IF vl_legis_ref IS NOT NULL THEN
2326: BEGIN
2327: SELECT advance_type
2328: INTO va_advance_type_val
2329: FROM fv_be_trx_dtls
2330: WHERE transaction_id = vl_legis_ref
2331: AND set_of_books_id = vp_set_of_books_id ;
2332: IF ( FND_LOG.LEVEL_STATEMENT >=
2333: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2381: FROM fv_be_trx_dtls

2377: SELECT dept_id,
2378: main_account
2379: INTO va_transfer_dept_id,
2380: va_transfer_main_acct
2381: FROM fv_be_trx_dtls
2382: WHERE transaction_id = vl_legis_ref
2383: AND set_of_books_id = vp_set_of_books_id ;
2384: IF ( FND_LOG.LEVEL_STATEMENT >=
2385: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN