DBA Data[Home] [Help]

APPS.IPA_APIS dependencies on PA_PROJECTS_ALL

Line 241: pa_projects_all pp,

237: l_book_type_code ,l_asset_units ,
238: l_asset_category_id ,l_asset_location_id ,
239: l_depreciate_flag ,l_depreciation_expense_ccid
240: FROM pa_project_assets_all pa,
241: pa_projects_all pp,
242: pa_project_types ppt
243: WHERE ( pa.project_asset_id = apis_rec.project_asset_id
244: OR pa.asset_number = apis_rec.asset_number
245: OR pa.asset_name = apis_rec.asset_name )

Line 289: FROM pa_projects_all pp,

285: ppt.interface_asset_cost_code, ppt.interface_complete_asset_flag
286: INTO l_project_id , l_project_name ,
287: l_project_number, l_project_type,
288: l_interface_asset_cost_code , l_xface_complete_asset_flag
289: FROM pa_projects_all pp,
290: pa_project_types ppt
291: WHERE (pp.project_id = apis_rec.project_id
292: OR pp.name = apis_rec.project_name
293: OR pp.segment1 = apis_rec.project_number)

Line 338: FROM pa_projects_all pp,

334: ppt.interface_asset_cost_code, ppt.interface_complete_asset_flag
335: INTO l_project_id , l_project_name ,
336: l_project_number, l_project_type,
337: l_interface_asset_cost_code , l_xface_complete_asset_flag
338: FROM pa_projects_all pp,
339: pa_project_types ppt
340: WHERE (pp.project_id = apis_rec.project_id
341: OR pp.name = apis_rec.project_name
342: OR pp.segment1 = apis_rec.project_number)