APPS.AHL_VWP_MR_CST_PR_PVT dependencies on AHL_VISIT_TASKS_VL

Line 64: From ahl_visit_tasks_VL

60: PRICE_LIST_ID,
61: SERVICE_REQUEST_ID,
62: VISIT_TASK_NAME,
63: VISIT_TASK_NUMBER
64: From ahl_visit_tasks_VL
65: where visit_task_id=c_visit_task_id;
66:
67: l_task_rec c_task_csr%rowtype;
68:

Line 553: FROM ahl_visit_tasks_vl VST

549:
550: --Post11510. Added to get summary task start, end time
551: CURSOR get_summary_task_times_csr(x_task_id IN NUMBER)IS
552: SELECT min(start_date_time)
553: FROM ahl_visit_tasks_vl VST
554: START WITH visit_task_id = x_task_id
555: AND NVL(VST.status_code, 'Y') <> NVL ('DELETED', 'X')
556: CONNECT BY originating_task_id = PRIOR visit_task_id;
557:

Line 1230: from Ahl_visit_tasks_vl

1226: Select visit_task_id,
1227: visit_id,
1228: price_list_id,
1229: mr_id, start_date_time
1230: from Ahl_visit_tasks_vl
1231: where visit_task_id=c_task_id;
1232: l_task_rec c_task_csr%rowtype;
1233:
1234: Cursor c_visit_csr(c_visit_id number)

Line 1311: from ahl_visit_tasks_vl tsk,

1307: select mrb.title mr_name,
1308: mrtl.description mr_description,
1309: visit_task_number task_number,
1310: visit_task_name task_name
1311: from ahl_visit_tasks_vl tsk,
1312: ahl_mr_headers_tl mrtl,
1313: ahl_mr_headers_b mrb,
1314: ahl_mr_routes mrr,
1315: ahl_visits_vl avts

Line 1330: from ahl_visit_tasks_vl tsk,

1326: select title mr_name,
1327: mrh.description mr_description,
1328: visit_task_number task_number,
1329: visit_task_name task_name
1330: from ahl_visit_tasks_vl tsk,
1331: ahl_mr_headers_vl mrh,
1332: AHL_VISITS_VL AVTS
1333: where MRH.MR_HEADER_ID = TSK.MR_ID
1334: AND NVL(TSK.STATUS_CODE,'X') <> 'DELETED'

Line 1370: FROM ahl_visit_tasks_vl VST

1366:
1367: --Post11510. Added to get summary task start, end time
1368: CURSOR get_summary_task_times_csr(x_task_id IN NUMBER)IS
1369: SELECT min(start_date_time)
1370: FROM ahl_visit_tasks_vl VST
1371: START WITH visit_task_id = x_task_id
1372: AND NVL(VST.status_code, 'Y') <> NVL ('DELETED', 'X')
1373: CONNECT BY originating_task_id = PRIOR visit_task_id;
1374:

Line 2075: FROM AHL_VISIT_TASKS_VL

2071:
2072: Cursor c_task_rec(c_visit_task_id NUMBER)
2073: Is
2074: SELECT actual_price,ESTIMATEd_price, MR_Id
2075: FROM AHL_VISIT_TASKS_VL
2076: WHERE VISIT_TASK_ID=C_VISIT_TASK_ID;
2077:
2078: l_visit_task_rec c_task_rec%rowtype;
2079: