DBA Data[Home] [Help]

APPS.GMS_PO_API_GRP dependencies on GMS_PROJECT_TYPES

Line 913: gms_project_types gpt ,

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
917: and p.project_type = pt.project_type ;

Line 1740: gms_project_types pt

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' ;
1744: