APPS.IPA_APIS dependencies on PA_PROJECT_TYPES

Line 7: l_interface_asset_cost_code pa_project_types.interface_asset_cost_code%TYPE ;

3:
4: PROCEDURE summarize_dpis (
5: errbug IN OUT NOCOPY VARCHAR2 ,
6: retcode IN OUT NOCOPY varchar2 ) IS
7: l_interface_asset_cost_code pa_project_types.interface_asset_cost_code%TYPE ;
8: l_xface_complete_asset_flag pa_project_types.interface_complete_asset_flag%TYPE;
9: l_earliest_fa_dpis DATE ;
10: l_project_id pa_projects.project_id%TYPE ;
11: l_project_number pa_projects.segment1%TYPE;

Line 8: l_xface_complete_asset_flag pa_project_types.interface_complete_asset_flag%TYPE;

4: PROCEDURE summarize_dpis (
5: errbug IN OUT NOCOPY VARCHAR2 ,
6: retcode IN OUT NOCOPY varchar2 ) IS
7: l_interface_asset_cost_code pa_project_types.interface_asset_cost_code%TYPE ;
8: l_xface_complete_asset_flag pa_project_types.interface_complete_asset_flag%TYPE;
9: l_earliest_fa_dpis DATE ;
10: l_project_id pa_projects.project_id%TYPE ;
11: l_project_number pa_projects.segment1%TYPE;
12: l_project_name pa_projects.name%TYPE ;

Line 242: pa_project_types ppt

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 )
246: AND capitalized_flag <> 'Y'

Line 291: pa_project_types ppt

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)
295: AND pp.project_type = ppt.project_type

Line 341: pa_project_types ppt

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)
345: AND pp.project_type = ppt.project_type