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_PO_API_GRP dependencies on PA_PROJECTS_ALL

Line 912: from pa_projects_all p,

908: l_project_type_class_code pa_project_types_all.project_type_class_code%TYPE ;
909:
910: cursor C_spon_project is
911: select gpt.sponsored_flag , pt.project_type_class_code
912: from pa_projects_all p,
913: gms_project_types gpt ,
914: pa_project_types pt
915: where p.project_id = NVL(p_project_id,0)
916: and p.project_type = gpt.project_type

Line 1739: from pa_projects_all b,

1735: FUNCTION IS_SPONSORED_PROJECT( p_project_id in NUMBER ) return varchar2
1736: is
1737: cursor C_spon_project is
1738: select pt.sponsored_flag
1739: from pa_projects_all b,
1740: gms_project_types pt
1741: where b.project_id = p_project_id
1742: and b.project_type = pt.project_type
1743: and pt.sponsored_flag = 'Y' ;