APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_VISIT_TASKS_VL

Line 1147: FROM ahl_visit_tasks_vl

1143: -- Added by mpothuku on 12/22/04 to retrieve the associated simulation visits.
1144: CURSOR Get_simul_visit_tasks_cur(C_VISIT_ID IN NUMBER)
1145: IS
1146: SELECT visit_task_id
1147: FROM ahl_visit_tasks_vl
1148: WHERE visit_id = C_VISIT_ID;
1149:
1150: -- End mpothuku
1151:

Line 1519: FROM AHL_VISIT_TASKS_VL

1515: ATTRIBUTE12,
1516: ATTRIBUTE13,
1517: ATTRIBUTE14,
1518: ATTRIBUTE15
1519: FROM AHL_VISIT_TASKS_VL
1520: WHERE visit_id = c_visit_id
1521: AND STATUS_CODE <> 'DELETED';
1522: --
1523: CURSOR Get_space_Assign_cur (c_visit_id IN NUMBER) IS

Line 1668: FROM Ahl_Visit_tasks_vl

1664: and ahlsp.primary_plan_flag = 'Y';
1665:
1666: CURSOR c_task(c_task_id IN NUMBER) IS
1667: SELECT *
1668: FROM Ahl_Visit_tasks_vl
1669: WHERE visit_task_id = c_task_id;
1670:
1671: -- To find the coresponding Stage id in the new visit
1672: CURSOR c_new_stage_id(c_old_stage_id IN NUMBER, c_new_visit_id IN NUMBER) IS

Line 2481: FROM ahl_visit_tasks_vl

2477: --
2478: CURSOR get_visit_task_cur (c_visit_id IN NUMBER)
2479: IS
2480: SELECT *
2481: FROM ahl_visit_tasks_vl
2482: WHERE visit_id = c_visit_id;
2483: --
2484: CURSOR Check_space_cur (c_visit_id IN NUMBER)
2485: IS

Line 3346: FROM ahl_visit_tasks_vl ATSK,

3342: ATSK.ATTRIBUTE14,
3343: ATSK.ATTRIBUTE15,
3344: MTSB.CONCATENATED_SEGMENTS ITEM_NAME,
3345: CSIS.SERIAL_NUMBER SERIAL_NUMBER
3346: FROM ahl_visit_tasks_vl ATSK,
3347: MTL_SYSTEM_ITEMS_B_KFV MTSB,
3348: CSI_ITEM_INSTANCES CSIS
3349: WHERE visit_id = c_visit_id and
3350: ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+) and

Line 3359: FROM ahl_visit_tasks_vl

3355: CURSOR check_visit_task_cur (c_visit_id IN NUMBER,
3356: c_visit_task_id IN NUMBER)
3357: IS
3358: SELECT visit_task_id
3359: FROM ahl_visit_tasks_vl
3360: WHERE visit_id = c_visit_id
3361: AND visit_task_id = c_visit_task_id
3362: AND status_code <> 'DELETED';
3363:

Line 3368: FROM ahl_visit_tasks_vl

3364: -- Check for tasks exist in primary visit tasks which are not in simulation visit
3365: CURSOR check_exist_visit_task_cur (c_visit_id IN NUMBER)
3366: IS
3367: SELECT visit_task_id
3368: FROM ahl_visit_tasks_vl
3369: WHERE visit_id = c_visit_id;
3370:
3371: -- Check for tasks exist in primary visit tasks which are not in simulation visit
3372: CURSOR check_prim_visit_task_cur (c_visit_id IN NUMBER,

Line 3376: FROM ahl_visit_tasks_vl

3372: CURSOR check_prim_visit_task_cur (c_visit_id IN NUMBER,
3373: c_visit_task_id IN NUMBER)
3374: IS
3375: SELECT primary_visit_task_id
3376: FROM ahl_visit_tasks_vl
3377: WHERE visit_id = c_visit_id
3378: AND primary_visit_task_id = c_visit_task_id
3379: AND status_code <> 'DELETED' ;
3380:

Line 3385: FROM Ahl_Visit_Tasks_VL

3381: --Get tasks that needs deletion
3382: CURSOR get_tasks_delete_csr(x_id IN NUMBER)
3383: IS
3384: SELECT visit_task_id,object_version_number,visit_task_number
3385: FROM Ahl_Visit_Tasks_VL
3386: WHERE VISIT_ID = x_id AND NVL(STATUS_CODE,'X') <> 'DELETED'
3387: AND ((TASK_TYPE_CODE = 'SUMMARY' AND ORIGINATING_TASK_ID IS NULL)
3388: OR TASK_TYPE_CODE = 'UNASSOCIATED'
3389: OR (TASK_TYPE_CODE = 'SUMMARY' AND MR_ID IS NULL));

Line 3543: FROM Ahl_Visit_tasks_vl

3539: WHERE VISIT_ID = x_id;
3540:
3541: CURSOR c_task(c_task_id IN NUMBER) IS
3542: SELECT *
3543: FROM Ahl_Visit_tasks_vl
3544: WHERE visit_task_id = c_task_id;
3545:
3546: CURSOR c_new_primary_task (c_simulation_task_id IN NUMBER) IS
3547: SELECT prim.visit_task_id, prim.visit_task_number FROM

Line 4737: FROM ahl_visit_tasks_vl

4733: -- Get all the associated tasks
4734: CURSOR Get_simul_visit_tasks_cur(C_VISIT_ID IN NUMBER)
4735: IS
4736: SELECT visit_task_id
4737: FROM ahl_visit_tasks_vl
4738: WHERE visit_id = C_VISIT_ID;
4739:
4740: --
4741: