DBA Data[Home] [Help]

APPS.GMS_PO_API_GRP dependencies on PA_PROJECT_TYPES

Line 908: l_project_type_class_code pa_project_types_all.project_type_class_code%TYPE ;

904: l_api_name varchar2(50) := 'validate_transaction' ;
905: l_sponsored_flag varchar2(1) ;
906: l_gms_enabled BOOLEAN ;
907: l_spon_project BOOLEAN ;
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,

Line 914: pa_project_types pt

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 ;
918: