APPS.AHL_VWP_MR_CST_PR_PVT dependencies on AHL_VISITS_VL

Line 89: From ahl_visits_vl

85: OUTSIDE_PARTY_FLAG,
86: ORGANIZATION_ID,
87: START_DATE_TIME,
88: CLOSE_DATE_TIME
89: From ahl_visits_vl
90: where visit_id=c_visit_id;
91: l_visit_rec c_visit_csr%rowtype;
92:
93: Cursor c_work_csr(c_visit_task_id in number)

Line 1315: ahl_visits_vl avts

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
1316: where tsk.mr_route_id = mrr.mr_route_id(+)
1317: and mrr.mr_header_id = mrb.mr_header_id(+)
1318: and mrb.mr_header_id = mrtl.mr_header_id (+)
1319: and mrtl.language(+) = USERENV('LANG')

Line 1332: AHL_VISITS_VL AVTS

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'
1335: AND AVTS.VISIT_ID = TSK.VISIT_ID
1336: AND AVTS.TEMPLATE_FLAG = 'N'