APPS.FV_BE_INT_PKG dependencies on FV_BE_TRANSACTION_TYPES

Line 178: v_tt_id fv_be_transaction_types.be_tt_id%TYPE;

174: dtl_index NUMBER;
175: v_rej_rec_count NUMBER;
176:
177: v_amount fv_be_trx_dtls.amount%TYPE;
178: v_tt_id fv_be_transaction_types.be_tt_id%TYPE;
179: v_gl_date fv_be_trx_dtls.gl_date%TYPE;
180: v_quarter_num fv_be_trx_dtls.quarter_num%TYPE;
181: v_doc_id fv_be_trx_hdrs.doc_id%TYPE;
182: v_doc_status fv_be_trx_hdrs.doc_status%TYPE;

Line 1240: FROM fv_be_transaction_types

1236: INTO v_tt_id,
1237: g_pub_law_code_flag,
1238: g_advance_flag,
1239: g_transfer_flag
1240: FROM fv_be_transaction_types
1241: WHERE set_of_books_id = valid_rec.set_of_books_id
1242: AND budget_level_id = valid_rec.budget_level_id
1243: AND apprn_transaction_type = valid_rec.transaction_type;
1244:

Line 2031: FROM fv_be_transaction_types

2027: SELECT public_law_code_flag, advance_flag,
2028: transfer_flag, sub_type_flag
2029: INTO g_pub_law_code_flag, g_advance_flag,
2030: g_transfer_flag,g_sub_type_flag
2031: FROM fv_be_transaction_types
2032: WHERE set_of_books_id = v_set_of_books_id
2033: AND budget_level_id = v_budget_level_id
2034: AND apprn_transaction_type = v_trx_type;
2035:

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

2071: Transaction Type');
2072: reset_control_status;
2073: END validate_trx_type_attribs;
2074: --------------------------------------------------------------------------------
2075: -- Check for default transaction code in fv_be_transaction_types
2076: -- If default transaction code is not equal to the trx code
2077: -- then check the transaction code for that transaction type
2078: -- in fv_be_trx_codes. If the transaction code does not exist
2079: -- in fv_be_trx_codes then the record is in error

Line 2093: FROM fv_be_transaction_types

2089: l_module_name := g_module_name || 'VALIDATE_SUB_TYPE';
2090:
2091: SELECT sub_type_flag
2092: INTO l_subtype_flag
2093: FROM fv_be_transaction_types
2094: WHERE set_of_books_id = v_set_of_books_id
2095: AND budget_level_id = v_budget_level_id
2096: AND apprn_transaction_type = v_trx_type;
2097:

Line 2104: FROM FV_BE_TRANSACTION_TYPES T, FV_BE_TRX_SUB_TYPES S

2100: IF (l_subtype_flag ='Y' ) or (V_SUB_TYPE is not null) THEN
2101:
2102: SELECT 'X'
2103: INTO v_exists
2104: FROM FV_BE_TRANSACTION_TYPES T, FV_BE_TRX_SUB_TYPES S
2105: WHERE T.BE_TT_ID = S.BE_TT_ID
2106: AND T.BUDGET_LEVEL_ID = V_BUDGET_LEVEL_ID
2107: AND T.APPRN_TRANSACTION_TYPE = V_TRX_TYPE
2108: AND S.SUB_TYPE = V_SUB_TYPE;