APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_VISIT_TASKS_VL

Line 1143: FROM ahl_visit_tasks_vl

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

Line 1503: FROM AHL_VISIT_TASKS_VL

1499: ATTRIBUTE12,
1500: ATTRIBUTE13,
1501: ATTRIBUTE14,
1502: ATTRIBUTE15
1503: FROM AHL_VISIT_TASKS_VL
1504: WHERE visit_id = c_visit_id
1505: AND STATUS_CODE <> 'DELETED';
1506: --
1507: CURSOR Get_space_Assign_cur (c_visit_id IN NUMBER) IS

Line 1652: FROM Ahl_Visit_tasks_vl

1648: and ahlsp.primary_plan_flag = 'Y';
1649:
1650: CURSOR c_task(c_task_id IN NUMBER) IS
1651: SELECT *
1652: FROM Ahl_Visit_tasks_vl
1653: WHERE visit_task_id = c_task_id;
1654:
1655: -- To find the coresponding Stage id in the new visit
1656: CURSOR c_new_stage_id(c_old_stage_id IN NUMBER, c_new_visit_id IN NUMBER) IS

Line 2442: FROM ahl_visit_tasks_vl

2438: --
2439: CURSOR get_visit_task_cur (c_visit_id IN NUMBER)
2440: IS
2441: SELECT *
2442: FROM ahl_visit_tasks_vl
2443: WHERE visit_id = c_visit_id;
2444: --
2445: CURSOR Check_space_cur (c_visit_id IN NUMBER)
2446: IS

Line 3300: FROM ahl_visit_tasks_vl ATSK,

3296: ATSK.ATTRIBUTE14,
3297: ATSK.ATTRIBUTE15,
3298: MTSB.CONCATENATED_SEGMENTS ITEM_NAME,
3299: CSIS.SERIAL_NUMBER SERIAL_NUMBER
3300: FROM ahl_visit_tasks_vl ATSK,
3301: MTL_SYSTEM_ITEMS_B_KFV MTSB,
3302: CSI_ITEM_INSTANCES CSIS
3303: WHERE visit_id = c_visit_id and
3304: ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+) and

Line 3313: FROM ahl_visit_tasks_vl

3309: CURSOR check_visit_task_cur (c_visit_id IN NUMBER,
3310: c_visit_task_id IN NUMBER)
3311: IS
3312: SELECT visit_task_id
3313: FROM ahl_visit_tasks_vl
3314: WHERE visit_id = c_visit_id
3315: AND visit_task_id = c_visit_task_id
3316: AND status_code <> 'DELETED';
3317:

Line 3322: FROM ahl_visit_tasks_vl

3318: -- Check for tasks exist in primary visit tasks which are not in simulation visit
3319: CURSOR check_exist_visit_task_cur (c_visit_id IN NUMBER)
3320: IS
3321: SELECT visit_task_id
3322: FROM ahl_visit_tasks_vl
3323: WHERE visit_id = c_visit_id;
3324:
3325: -- Check for tasks exist in primary visit tasks which are not in simulation visit
3326: CURSOR check_prim_visit_task_cur (c_visit_id IN NUMBER,

Line 3330: FROM ahl_visit_tasks_vl

3326: CURSOR check_prim_visit_task_cur (c_visit_id IN NUMBER,
3327: c_visit_task_id IN NUMBER)
3328: IS
3329: SELECT primary_visit_task_id
3330: FROM ahl_visit_tasks_vl
3331: WHERE visit_id = c_visit_id
3332: AND primary_visit_task_id = c_visit_task_id
3333: AND status_code <> 'DELETED' ;
3334:

Line 3339: FROM Ahl_Visit_Tasks_VL

3335: --Get tasks that needs deletion
3336: CURSOR get_tasks_delete_csr(x_id IN NUMBER)
3337: IS
3338: SELECT visit_task_id,object_version_number,visit_task_number
3339: FROM Ahl_Visit_Tasks_VL
3340: WHERE VISIT_ID = x_id AND NVL(STATUS_CODE,'X') <> 'DELETED'
3341: AND ((TASK_TYPE_CODE = 'SUMMARY' AND ORIGINATING_TASK_ID IS NULL)
3342: OR TASK_TYPE_CODE = 'UNASSOCIATED'
3343: OR (TASK_TYPE_CODE = 'SUMMARY' AND MR_ID IS NULL));

Line 3497: FROM Ahl_Visit_tasks_vl

3493: WHERE VISIT_ID = x_id;
3494:
3495: CURSOR c_task(c_task_id IN NUMBER) IS
3496: SELECT *
3497: FROM Ahl_Visit_tasks_vl
3498: WHERE visit_task_id = c_task_id;
3499:
3500: CURSOR c_new_primary_task (c_simulation_task_id IN NUMBER) IS
3501: SELECT prim.visit_task_id, prim.visit_task_number FROM

Line 4673: FROM ahl_visit_tasks_vl

4669: -- Get all the associated tasks
4670: CURSOR Get_simul_visit_tasks_cur(C_VISIT_ID IN NUMBER)
4671: IS
4672: SELECT visit_task_id
4673: FROM ahl_visit_tasks_vl
4674: WHERE visit_id = C_VISIT_ID;
4675:
4676: --
4677: