1703: end if;
1704: If NVL(x_gl_ccid,0) = 0 then
1705: SELECT nvl(completion_date,l_payroll_end_date)
1706: INTO l_project_end_date 1707: FROM pa_projects_all 1708: WHERE project_id = x_project_id;
1709: --
1710: SELECT nvl(end_date_active,l_payroll_end_date)
1711: INTO l_award_end_date