DBA Data[Home] [Help]

APPS.CSE_FA_INTEGRATION_GRP dependencies on PA_PROJECT_ASSET_LINE_DETAILS

Line 200: pa_project_asset_line_details ppald,

196: CURSOR proj_cur(p_project_asset_line_id IN number) IS
197: SELECT pei.expenditure_item_id,
198: pei.orig_transaction_reference txn_ref
199: FROM pa_expenditure_items_all pei,
200: pa_project_asset_line_details ppald,
201: pa_project_asset_lines_all ppal
202: WHERE ppal.project_asset_line_id = p_project_asset_line_id
203: AND ppald.project_asset_line_detail_id = ppal.project_asset_line_detail_id
204: AND pei.expenditure_item_id = ppald.expenditure_item_id

Line 479: pa_project_asset_line_details ppald,

475: ppa.location_id,
476: ppa.depreciation_expense_ccid expense_ccid,
477: ppa.assigned_to_person_id employee_id
478: FROM pa_expenditure_items_all pei,
479: pa_project_asset_line_details ppald,
480: pa_project_asset_lines_all ppal,
481: pa_project_assets_all ppa
482: WHERE ppal.project_asset_line_id = p_project_asset_line_id
483: AND ppa.project_asset_id = ppal.project_asset_id