DBA Data[Home] [Help]

APPS.CSE_FA_INTEGRATION_GRP dependencies on PA_PROJECT_ASSET_LINES_ALL

Line 201: pa_project_asset_lines_all ppal

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
205: AND pei.transaction_source IN ('CSE_PO_RECEIPT','CSE_INV_ISSUE')

Line 480: pa_project_asset_lines_all ppal,

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
484: AND ppald.project_asset_line_detail_id = ppal.project_asset_line_detail_id