DBA Data[Home] [Help]

APPS.GMS_TRANSACTIONS_PUB dependencies on GMS_PROJECT_TYPES

Line 38: gms_project_types gpt

34: Select nvl(gpt.sponsored_flag,'N')
35: into Sponsor_Flag
36: from pa_tasks t,
37: pa_projects_all p,
38: gms_project_types gpt
39: where t.task_id = P_Task_Id and
40: p.project_id = t.project_id and
41: gpt.project_type = p.project_type;
42:

Line 820: gms_project_types pt

816: is
817: cursor C_spon_project is
818: select pt.sponsored_flag
819: from pa_projects_all b,
820: gms_project_types pt
821: where b.project_id = X_project_id
822: and b.project_type = pt.project_type
823: and pt.sponsored_flag = 'Y' ;
824: