DBA Data[Home] [Help]

APPS.PSP_GENERAL dependencies on GMS_PROJECT_TYPES

Line 1828: gms_project_types gpt -- Changed from gms_project_types_all for P1 bug 4078481

1824: FUNCTION get_sponsored_flag (p_project_id IN NUMBER) RETURN VARCHAR2 IS
1825: CURSOR sponsored_flag_cur IS
1826: SELECT sponsored_flag
1827: FROM pa_projects_all ppa,
1828: gms_project_types gpt -- Changed from gms_project_types_all for P1 bug 4078481
1829: WHERE gpt.project_type = ppa.project_type
1830: AND ppa.project_type <> 'AWARD_PROJECT'
1831: AND ppa.project_id = p_project_id;
1832: