DBA Data[Home] [Help]

APPS.GMS_POR_API dependencies on PA_PROJECTS_ALL

Line 255: from pa_projects_all b,

251: FUNCTION IS_SPONSORED_PROJECT( x_project_id in NUMBER ) return BOOLEAN
252: is
253: cursor C_spon_project is
254: select pt.sponsored_flag
255: from pa_projects_all b,
256: gms_project_types pt
257: where b.project_id = X_project_id
258: and b.project_type = pt.project_type
259: and pt.sponsored_flag = 'Y' ;

Line 338: pa_projects_all b

334: --Bug 2579915
335: Cursor valid_project_type_class is
336: select project_type_class_code
337: from pa_project_types a,
338: pa_projects_all b
339: where a.project_type = b.project_type
340: and b.project_id = X_project_id;
341:
342:

Line 595: from pa_projects_all b,

591: l_status varchar2(1) ;
592:
593: cursor C_spon_project is
594: select pt.sponsored_flag
595: from pa_projects_all b,
596: gms_project_types pt
597: where b.project_id = X_project_id
598: and b.project_type = pt.project_type
599: and pt.sponsored_flag = 'Y' ;