APPS.GMS_TRANSACTIONS_PUB dependencies on PA_PROJECTS_ALL

Line 37: pa_projects_all p,

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

Line 819: from pa_projects_all b,

815: FUNCTION IS_SPONSORED_PROJECT( x_project_id in NUMBER ) return BOOLEAN
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' ;

Line 924: pa_projects_all b

920: begin
921: select project_type_class_code
922: into l_project_type_class_code
923: from pa_project_types_all a,
924: pa_projects_all b
925: where a.project_type = b.project_type
926: and a.org_id = b.org_id /*For Bug 5414832*/
927: and b.project_id = X_project_id;
928: