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 290: FROM pa_projects_all pp,

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

Line 340: FROM pa_projects_all pp,

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