DBA Data[Home] [Help]

APPS.GMS_AWARD_DIST_ENG dependencies on GMS_PROJECT_TYPES

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

1736: l_task_id pa_tasks.task_id%TYPE ;
1737: l_task_id_last pa_tasks.task_id%TYPE ;
1738: l_task_number pa_tasks.task_number%TYPE ;
1739: l_task_number_last pa_tasks.task_number%TYPE ;
1740: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;
1741: l_sponsored_flag pa_project_types.sponsored_flag%TYPE ; --bug 4712763
1742:
1743: cursor c_project_id is
1744: select project_id

Line 1782: gms_project_types gpt

1778: --
1779: cursor c_sponsored_flag is
1780: select sponsored_flag
1781: from pa_projects_all p,
1782: gms_project_types gpt
1783: where p.project_id = l_project_id
1784: and p.project_type = gpt.project_type ;
1785:
1786: -- PA.L Changes