DBA Data[Home] [Help]

APPS.FV_BE_INT_PKG dependencies on FV_BE_ACCOUNT_PAIRS

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

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

Line 164: FROM fv_be_account_pairs acc,

160:
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;