APPS.FV_BE_INT_PKG dependencies on FV_BE_TRX_SUB_TYPES

Line 165: fv_be_trx_sub_types tst

161: CURSOR accounts_cur(p_sub_type IN VARCHAR2) IS
162: SELECT cr_account_segment_value,
163: dr_account_segment_value
164: FROM fv_be_account_pairs acc,
165: fv_be_trx_sub_types tst
166: WHERE acc.be_tt_id = tst.be_tt_id
167: and tst.sub_type =p_sub_type
168: AND chart_of_accounts_id = v_coa_id;
169:

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;