APPS.AHL_VWP_PROJ_PROD_PVT dependencies on PA_PROJECTS_ALL

Line 2550: FROM ahl_visits_b avb, pa_projects_all ppa

2546: /*sowsubra - starts*/
2547: -- To get the project status for visit updation
2548: CURSOR c_proj_status_code(x_id IN NUMBER) IS
2549: SELECT ppa.project_status_code
2550: FROM ahl_visits_b avb, pa_projects_all ppa
2551: WHERE avb.visit_id = x_id
2552: AND avb.project_id = ppa.project_id;
2553:
2554: l_prj_status_code_fdb pa_projects_all.project_status_code%TYPE;

Line 2554: l_prj_status_code_fdb pa_projects_all.project_status_code%TYPE;

2550: FROM ahl_visits_b avb, pa_projects_all ppa
2551: WHERE avb.visit_id = x_id
2552: AND avb.project_id = ppa.project_id;
2553:
2554: l_prj_status_code_fdb pa_projects_all.project_status_code%TYPE;
2555: /*sowsubra - ends*/
2556:
2557: /*
2558: Modified by rnahata for Bug 5758813

Line 2625: from pa_projects_all

2621: -- SKPATHAK :: Bug 14016007 :: 29-APR-2012 :: Added the below cursor
2622: --Fetch the project number
2623: CURSOR get_project_number (c_project_id IN NUMBER) IS
2624: SELECT segment1
2625: from pa_projects_all
2626: where project_id = c_project_id;
2627: l_project_number VARCHAR2(25);
2628:
2629: --PRAKKUM :: 11/06/2012 :: Bug 14068468 :: START

Line 12723: from pa_projects_all

12719:
12720: --Fetch the project start date
12721: CURSOR get_prj_start_date_csr (c_project_id IN NUMBER) IS
12722: SELECT start_date
12723: from pa_projects_all
12724: where project_id = c_project_id;
12725:
12726: BEGIN
12727: -- Initialize return status to success before any code logic/validation