DBA Data[Home] [Help]

APPS.FV_BE_INT_PKG dependencies on FV_BE_TRX_SUB_TYPES

Line 167: fv_be_trx_sub_types tst

163: p_ledger_id IN NUMBER) IS
164: SELECT cr_account_segment_value,
165: dr_account_segment_value
166: FROM fv_be_account_pairs acc,
167: fv_be_trx_sub_types tst
168: WHERE acc.be_tt_id = tst.be_tt_id
169: and tst.sub_type =p_sub_type
170: AND chart_of_accounts_id = v_coa_id
171: AND acc.ledger_id = tst.ledger_id

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