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 484: pa_project_asset_line_details ppald,

480: ppa.location_id,
481: ppa.depreciation_expense_ccid expense_ccid,
482: ppa.assigned_to_person_id employee_id
483: FROM pa_expenditure_items_all pei,
484: pa_project_asset_line_details ppald,
485: pa_project_asset_lines_all ppal,
486: pa_project_assets_all ppa
487: WHERE ppal.project_asset_line_id = p_project_asset_line_id
488: AND ppa.project_asset_id = ppal.project_asset_id