APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VWP_STAGES_VL

Line 469: AHL_VWP_STAGES_VL STAGES

465: CURSOR c_stages_without_types(c_visit_id IN NUMBER ) IS
466: SELECT DISTINCT STAGES.STAGE_ID ,
467: STAGES.STAGE_NAME
468: FROM AHL_VISIT_TASKS_B TASKS,
469: AHL_VWP_STAGES_VL STAGES
470: WHERE
471: TASKS.VISIT_ID= c_visit_id AND
472: STAGES.STAGE_ID=TASKS.STAGE_ID AND
473: TASKS.TASK_TYPE_CODE <> 'STAGE' AND --SKPATHAK :: stages not having any visit tasks need not be validated

Line 7797: AHL_VWP_STAGES_VL STAGES

7793: CURSOR c_stages_without_types(c_visit_id IN NUMBER ) IS
7794: SELECT DISTINCT STAGES.STAGE_ID ,
7795: STAGES.STAGE_NAME
7796: FROM AHL_VISIT_TASKS_B TASKS,
7797: AHL_VWP_STAGES_VL STAGES
7798: WHERE
7799: TASKS.VISIT_ID= c_visit_id AND
7800: STAGES.STAGE_ID=TASKS.STAGE_ID AND
7801: TASKS.TASK_TYPE_CODE <> 'STAGE' AND --SKPATHAK :: stages not having any visit tasks need not be validated

Line 8801: AHL_VWP_STAGES_VL STAGES

8797: STAGES.STAGE_NAME,
8798: STAGE_TYPES.STAGE_TYPE_CODE
8799: FROM AHL_VISIT_TASKS_B TASKS,
8800: AHL_VISIT_STAGE_TYP_ASOC STAGE_TYPES,
8801: AHL_VWP_STAGES_VL STAGES
8802: WHERE
8803: TASKS.VISIT_TASK_ID= c_vst_task_id AND
8804: TASKS.STAGE_ID=STAGE_TYPES.STAGE_ID(+) AND
8805: TASKS.STAGE_ID = STAGES.STAGE_ID;

Line 10488: AHL_VWP_STAGES_VL STAGES

10484: CURSOR c_stages_without_types(c_visit_id IN NUMBER, c_unit_effectivity_id IN NUMBER ) IS
10485: SELECT DISTINCT STAGES.STAGE_ID ,
10486: STAGES.STAGE_NAME
10487: FROM AHL_VISIT_TASKS_B TASKS,
10488: AHL_VWP_STAGES_VL STAGES
10489: WHERE
10490: TASKS.VISIT_ID= c_visit_id AND
10491: TASKS.UNIT_EFFECTIVITY_ID = c_unit_effectivity_id AND
10492: STAGES.STAGE_ID=TASKS.STAGE_ID AND