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
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