DBA Data[Home] [Help]

APPS.FV_BE_INT_PKG dependencies on FV_BE_ACCOUNT_PAIRS

Line 159: -- BCPSA-BE Enhancement - Modified the cursor below to pull the information from FV_BE_ACCOUNT_PAIRS

155: AND set_of_books_id = parm_ledger_id
156: AND status IN ('NEW','REJECTED','ACCEPTED')
157: ORDER BY budget_level_id ;
158:
159: -- BCPSA-BE Enhancement - Modified the cursor below to pull the information from FV_BE_ACCOUNT_PAIRS
160: -- instead of GL_USSGL_ACCOUNT_PAIRS table
161:
162: CURSOR accounts_cur(p_sub_type IN VARCHAR2,
163: p_ledger_id IN NUMBER) IS

Line 166: FROM fv_be_account_pairs acc,

162: CURSOR accounts_cur(p_sub_type IN VARCHAR2,
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