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 2246: gms_project_types gpt

2242: select nvl(sponsored_flag,'N')
2243: into l_sponsored_flag
2244: from pa_tasks t,
2245: pa_projects_all p,
2246: gms_project_types gpt
2247: where p.project_id = t.project_id
2248: and gpt.project_type = p.project_type
2249: and t.task_id = nvl(p_task_id,0);
2250: