DBA Data[Home] [Help]

APPS.GMS_AWARD_DIST_ENG dependencies on GMS_PROJECT_TYPES

Line 1606: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;

1602: l_task_id pa_tasks.task_id%TYPE ;
1603: l_task_id_last pa_tasks.task_id%TYPE ;
1604: l_task_number pa_tasks.task_number%TYPE ;
1605: l_task_number_last pa_tasks.task_number%TYPE ;
1606: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;
1607: l_sponsored_flag pa_project_types.sponsored_flag%TYPE ; --bug 4712763
1608:
1609: cursor c_project_id is
1610: select project_id

Line 1648: gms_project_types gpt

1644: --
1645: cursor c_sponsored_flag is
1646: select sponsored_flag
1647: from pa_projects_all p,
1648: gms_project_types gpt
1649: where p.project_id = l_project_id
1650: and p.project_type = gpt.project_type ;
1651:
1652: -- PA.L Changes