APPS.CSE_GL_INTERFACE_PKG dependencies on CST_ACCT_INFO_V

Line 80: from cst_acct_info_v caiv, mtl_transaction_accounts mta

76: WHERE nvl(xlte.source_id_int_1 , '-99') = c_mtl_transaction_id
77: AND xlte.entity_code = 'MTL_ACCOUNTING_EVENTS'
78: AND xlte.application_id = 707
79: and xlte.ledger_id in (select distinct caiv.ledger_id
80: from cst_acct_info_v caiv, mtl_transaction_accounts mta
81: where mta.transaction_id = c_mtl_transaction_id
82: and mta.organization_id = caiv.organization_id )
83: AND xlaeh.entity_id = xlte.entity_id
84: AND xlaeh.gl_transfer_status_code = 'NT' ;

Line 285: FROM cst_acct_info_v caiv,

281: CURSOR cst_acct_info_cur(c_mtl_transaction_id IN NUMBER ,
282: c_trf_txn_id IN NUMBER )
283: IS
284: SELECT distinct caiv.ledger_id , mmt.transaction_id
285: FROM cst_acct_info_v caiv,
286: mtl_transaction_accounts mta,
287: mtl_material_transactions mmt
288: WHERE mta.transaction_id = c_mtl_transaction_id
289: AND mta.organization_id = caiv.organization_id

Line 294: FROM cst_acct_info_v caiv,

290: AND mmt.transaction_id = c_mtl_transaction_id
291: AND mmt.transaction_action_id <> 3
292: UNION
293: SELECT distinct caiv.ledger_id , mmt.transaction_id
294: FROM cst_acct_info_v caiv,
295: mtl_transaction_accounts mta ,
296: mtl_material_transactions mmt
297: WHERE mta.transaction_id in ( c_mtl_transaction_id , c_trf_txn_id )
298: AND mta.organization_id = caiv.organization_id