461: WHERE rt.GROUP_ID = p_transaction_id;
462:
463: -- Fix For Bug: 4907062
464: -- a) Included Project Number in the cursor
465: -- b) Taken the project details from pjm_projects_mtll_v instead of pa_projects
466: CURSOR c_project IS
467: SELECT project_name, project_number
468: FROM pjm_projects_mtll_v --pa_projects
469: WHERE project_id = l_project_id;
464: -- a) Included Project Number in the cursor
465: -- b) Taken the project details from pjm_projects_mtll_v instead of pa_projects
466: CURSOR c_project IS
467: SELECT project_name, project_number
468: FROM pjm_projects_mtll_v --pa_projects
469: WHERE project_id = l_project_id;
470:
471: -- Fix For Bug: 4907062
472: -- Included Task Number in the cursor