APPS.FV_BE_INT_PKG dependencies on FV_BE_TRANSACTION_TYPES

Line 182: v_tt_id fv_be_transaction_types.be_tt_id%TYPE;

178: dtl_index NUMBER;
179: v_rej_rec_count NUMBER;
180:
181: v_amount fv_be_trx_dtls.amount%TYPE;
182: v_tt_id fv_be_transaction_types.be_tt_id%TYPE;
183: v_gl_date fv_be_trx_dtls.gl_date%TYPE;
184: v_quarter_num fv_be_trx_dtls.quarter_num%TYPE;
185: v_doc_id fv_be_trx_hdrs.doc_id%TYPE;
186: v_doc_status fv_be_trx_hdrs.doc_status%TYPE;

Line 1312: FROM fv_be_transaction_types

1308: INTO v_tt_id,
1309: g_pub_law_code_flag,
1310: g_advance_flag,
1311: g_transfer_flag
1312: FROM fv_be_transaction_types
1313: WHERE set_of_books_id = valid_rec.set_of_books_id
1314: AND budget_level_id = valid_rec.budget_level_id
1315: AND apprn_transaction_type = valid_rec.transaction_type;
1316:

Line 2118: FROM fv_be_transaction_types

2114: SELECT public_law_code_flag, advance_flag,
2115: transfer_flag, sub_type_flag
2116: INTO g_pub_law_code_flag, g_advance_flag,
2117: g_transfer_flag,g_sub_type_flag
2118: FROM fv_be_transaction_types
2119: WHERE set_of_books_id = v_set_of_books_id
2120: AND budget_level_id = v_budget_level_id
2121: AND apprn_transaction_type = v_trx_type;
2122:

Line 2162: -- Check for default transaction code in fv_be_transaction_types

2158: Transaction Type');
2159: reset_control_status;
2160: END validate_trx_type_attribs;
2161: --------------------------------------------------------------------------------
2162: -- Check for default transaction code in fv_be_transaction_types
2163: -- If default transaction code is not equal to the trx code
2164: -- then check the transaction code for that transaction type
2165: -- in fv_be_trx_codes. If the transaction code does not exist
2166: -- in fv_be_trx_codes then the record is in error

Line 2180: FROM fv_be_transaction_types

2176: l_module_name := g_module_name || 'VALIDATE_SUB_TYPE';
2177:
2178: SELECT sub_type_flag
2179: INTO l_subtype_flag
2180: FROM fv_be_transaction_types
2181: WHERE set_of_books_id = v_set_of_books_id
2182: AND budget_level_id = v_budget_level_id
2183: AND apprn_transaction_type = v_trx_type;
2184:

Line 2191: FROM FV_BE_TRANSACTION_TYPES T, FV_BE_TRX_SUB_TYPES S

2187: IF (l_subtype_flag ='Y' ) or (V_SUB_TYPE is not null) THEN
2188:
2189: SELECT 'X'
2190: INTO v_exists
2191: FROM FV_BE_TRANSACTION_TYPES T, FV_BE_TRX_SUB_TYPES S
2192: WHERE T.BE_TT_ID = S.BE_TT_ID
2193: AND T.BUDGET_LEVEL_ID = V_BUDGET_LEVEL_ID
2194: AND T.APPRN_TRANSACTION_TYPE = V_TRX_TYPE
2195: AND S.SUB_TYPE = V_SUB_TYPE