APPS.AHL_AVF_PRIM_VSTS_PVT dependencies on AHL_VISITS_B

Line 119: FROM ahl_visits_b

115:
116: -- Check The Validity of the visit_id passed.
117: CURSOR check_validity_visit (c_visit_id IN NUMBER) is
118: SELECT 'X'
119: FROM ahl_visits_b
120: WHERE visit_id = c_visit_id
121: AND nvl(locked_flag,'N') = 'N'
122: AND nvl(firmed_flag,'N') = 'N'
123: AND start_date_time IS NOT NULL

Line 135: FROM ahl_visits_b

131:
132: -- Getting Visit Details for a particular Visit.
133: CURSOR get_visit_details(c_visit_id IN NUMBER)IS
134: SELECT item_instance_id, start_date_time, close_date_time,nvl(space_category_code,0)
135: FROM ahl_visits_b
136: WHERE visit_id = c_visit_id;
137:
138: -- Check for the Parent MR
139:

Line 163: AND NOT exists (SELECT 'X' FROM ahl_visit_tasks_b task, ahl_visits_b visit

159: AND une.due_date is NOT NULL
160: AND (une.due_date between c_start_date AND c_end_date or (une.earliest_due_date between c_start_date AND c_end_date OR une.latest_due_date between c_start_date AND c_end_date))
161: AND NOT EXISTS (SELECT 'X' FROM ahl_ue_relationships uer WHERE uer.related_ue_id = une.unit_effectivity_id)
162: AND une.mr_header_id = mrh.mr_header_id
163: AND NOT exists (SELECT 'X' FROM ahl_visit_tasks_b task, ahl_visits_b visit
164: WHERE task.visit_id = visit.visit_id AND task.unit_effectivity_id = une.unit_effectivity_id
165: AND task.status_code NOT IN ('CANCELLED', 'DELETED'));
166:
167: -- Get the start and end dates of the Snapshot

Line 195: AND NOT exists (SELECT 'X' FROM ahl_visit_tasks_b task, ahl_visits_b visit

191: AND une.due_date IS NOT NULL
192: AND (une.due_date between c_start_date AND c_end_date or (une.earliest_due_date between c_start_date AND c_end_date OR une.latest_due_date between c_start_date AND c_end_date))
193: AND NOT EXISTS (SELECT 'X' FROM ahl_ue_relationships uer WHERE uer.related_ue_id = une.unit_effectivity_id)
194: AND une.mr_header_id = mrh.mr_header_id
195: AND NOT exists (SELECT 'X' FROM ahl_visit_tasks_b task, ahl_visits_b visit
196: WHERE task.visit_id = visit.visit_id AND task.unit_effectivity_id = une.unit_effectivity_id
197: AND task.status_code NOT IN ('CANCELLED', 'DELETED'));
198:
199: -- Get the correct VISIT_ID for the given UE_ID.

Line 205: FROM ahl_visits_b

201: c_category in NUMBER,
202: c_due_date in DATE,
203: c_lat_due_date in DATE) IS
204: SELECT visit_id
205: FROM ahl_visits_b
206: WHERE status_code IN ('PLANNING','RELEASED','PARTIALLY RELEASED')
207: AND item_instance_id = c_instance_id
208: AND nvl(locked_flag,'N') = 'N'
209: AND nvl(firmed_flag,'N') = 'N'

Line 610: FROM ahl_visits_b visit, ahl_unit_config_headers uch, ahl_autovisit_hierarchy avh, ahl_autovst_snpsht_hdr snap,ahl_mc_headers_b mc

606:
607: -- Get the Visits corresponding to the Start and End dates and Master configuration ids provided.
608: CURSOR get_visit_ids(c_snapshot_id IN NUMBER) IS
609: SELECT visit.visit_id, visit.object_version_number
610: FROM ahl_visits_b visit, ahl_unit_config_headers uch, ahl_autovisit_hierarchy avh, ahl_autovst_snpsht_hdr snap,ahl_mc_headers_b mc
611: WHERE visit.start_date_time IS NOT null AND visit.close_date_time IS NOT NULL
612: AND start_date_time >= snap.from_date
613: AND close_date_time <= snap.to_date
614: AND visit.status_code = L_STATUS_CODE

Line 1087: FROM ahl_visits_b

1083: --Cursors
1084:
1085: CURSOR get_visit_number(c_visit_id IN NUMBER) IS
1086: SELECT visit_number
1087: FROM ahl_visits_b
1088: WHERE visit_id = c_visit_id;
1089:
1090: Cursor get_mc_ids (c_snapshot_id IN NUMBER)
1091: IS