DBA Data[Home] [Help]

APPS.GMS_PA_API dependencies on GMS_PROJECT_TYPES

Line 510: gms_project_types gpt

506:
507: CURSOR C_SPONSORED IS
508: select 'X'
509: FROM pa_projects_all P,
510: gms_project_types gpt
511: WHERE p.project_id = X_project_id
512: AND p.project_type = gpt.project_type
513: and gpt.sponsored_flag = 'Y' ;
514: begin

Line 2233: gms_project_types gpt

2229: select nvl(sponsored_flag,'N')
2230: into l_sponsored_flag
2231: from pa_tasks t,
2232: pa_projects_all p,
2233: gms_project_types gpt
2234: where p.project_id = t.project_id
2235: and gpt.project_type = p.project_type
2236: and t.task_id = nvl(p_task_id,0);
2237: