APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VISIT_STAGE_TYP_ASOC

Line 476: FROM AHL_VISIT_STAGE_TYP_ASOC

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
474: NOT EXISTS (
475: SELECT STAGE_ID
476: FROM AHL_VISIT_STAGE_TYP_ASOC
477: WHERE STAGE_ID=STAGES.STAGE_ID);
478: l_invalid_stage BOOLEAN;
479: --CHANGES by jrotich bug #13028686 end
480:

Line 7804: FROM AHL_VISIT_STAGE_TYP_ASOC

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
7802: NOT EXISTS (
7803: SELECT STAGE_ID
7804: FROM AHL_VISIT_STAGE_TYP_ASOC
7805: WHERE STAGE_ID=STAGES.STAGE_ID);
7806: l_invalid_stage BOOLEAN;
7807: --CHANGES by jrotich bug #13028686 end
7808:

Line 8800: AHL_VISIT_STAGE_TYP_ASOC STAGE_TYPES,

8796: SELECT TASKS.STAGE_ID,
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

Line 10495: FROM AHL_VISIT_STAGE_TYP_ASOC

10491: TASKS.UNIT_EFFECTIVITY_ID = c_unit_effectivity_id AND
10492: STAGES.STAGE_ID=TASKS.STAGE_ID AND
10493: NOT EXISTS (
10494: SELECT STAGE_ID
10495: FROM AHL_VISIT_STAGE_TYP_ASOC
10496: WHERE STAGE_ID=STAGES.STAGE_ID);
10497: l_invalid_stage BOOLEAN;
10498: --CHANGES by jrotich bug #13028686 end
10499: