APPS.CSE_ASSET_CREATION_PKG dependencies on GL_SETS_OF_BOOKS

Line 400: , gl_sets_of_books sob

396: ,pod.set_of_books_id
397: FROM csi_inst_txn_details_v citdv
398: , po_distributions_all pod
399: , po_headers_all poh
400: , gl_sets_of_books sob
401: , mtl_transaction_accounts mta
402: WHERE citdv.transaction_id = p_transaction_id
403: AND citdv.source_dist_ref_id1 = pod.po_distribution_id
404: AND poh.po_header_id = pod.po_header_id

Line 410: FROM gl_sets_of_books gsob,

406: AND citdv.inv_material_transaction_id(+) = mta.transaction_id;
407:
408: CURSOR base_currency_cur IS
409: SELECT gsob.currency_code
410: FROM gl_sets_of_books gsob,
411: fa_book_controls fbc
412: WHERE fbc.book_type_code = p_book_type_code
413: AND gsob.set_of_books_id = fbc.set_of_books_id ;
414:

Line 871: gl_sets_of_books gsob,

867: NULL, ROUND(l_derived_asset_unit_cost, FC.precision),
868: ROUND(l_derived_asset_unit_cost/FC.minimum_accountable_unit) * FC.minimum_accountable_unit)
869: INTO l_derived_asset_unit_cost
870: FROM fnd_currencies fc,
871: gl_sets_of_books gsob,
872: fa_book_controls fbc
873: WHERE fbc.book_type_code = l_book_type_code
874: AND gsob.set_of_books_id = fbc.set_of_books_id
875: AND fc.currency_code = gsob.currency_code;