DBA Data[Home] [Help]

APPS.CSE_FA_INTEGRATION_GRP dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 199: FROM pa_expenditure_items_all pei,

195:
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

Line 483: FROM pa_expenditure_items_all pei,

479: pei.attribute10 product_class,
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