eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_POR_API dependencies on PA_PROJECTS_ALL

Line 211: from pa_projects_all b,

207: FUNCTION IS_SPONSORED_PROJECT( x_project_id in NUMBER ) return BOOLEAN
208: is
209: cursor C_spon_project is
210: select pt.sponsored_flag
211: from pa_projects_all b,
212: gms_project_types pt
213: where b.project_id = X_project_id
214: and b.project_type = pt.project_type
215: and pt.sponsored_flag = 'Y' ;

Line 281: pa_projects_all b

277: --Bug 2579915
278: Cursor valid_project_type_class is
279: select project_type_class_code
280: from pa_project_types a,
281: pa_projects_all b
282: where a.project_type = b.project_type
283: and b.project_id = X_project_id;
284:
285:

Line 513: from pa_projects_all b,

509: l_status varchar2(1) ;
510:
511: cursor C_spon_project is
512: select pt.sponsored_flag
513: from pa_projects_all b,
514: gms_project_types pt
515: where b.project_id = X_project_id
516: and b.project_type = pt.project_type
517: and pt.sponsored_flag = 'Y' ;