APPS.AHL_AVF_PRIM_VSTS_PVT dependencies on AHL_AUTOVST_SNPSHT_HDR

Line 129: FROM ahl_autovst_snpsht_hdr

125:
126: -- Check The Validity of the snapshot_id passed.
127: CURSOR check_validity_snapshot(c_snapshot_id in NUMBER) IS
128: SELECT 'X'
129: FROM ahl_autovst_snpsht_hdr
130: WHERE snapshot_id = c_snapshot_id;
131:
132: -- Getting Visit Details for a particular Visit.
133: CURSOR get_visit_details(c_visit_id IN NUMBER)IS

Line 170: FROM ahl_autovst_snpsht_hdr

166:
167: -- Get the start and end dates of the Snapshot
168: CURSOR get_dates(c_snapshot_id in NUMBER) IS
169: SELECT from_date,to_date
170: FROM ahl_autovst_snpsht_hdr
171: WHERE snapshot_id = c_snapshot_id;
172:
173: -- Get the MC_IDs for the given Snapshot
174: CURSOR get_mc_ids(c_snapshot_id in NUMBER) IS

Line 604: FROM ahl_autovst_snpsht_hdr

600:
601: -- Check the snapshot_id is valid or not.
602: CURSOR check_validity(c_snapshot_id IN NUMBER) IS
603: SELECT 'X'
604: FROM ahl_autovst_snpsht_hdr
605: WHERE snapshot_id = c_snapshot_id;
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

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 1131: from ahl_autovst_snpsht_hdr

1127:
1128: -- Get the start and end dates of a given Snapshot
1129: cursor get_dates(c_snapshot_id IN NUMBER) is
1130: select from_date,to_date
1131: from ahl_autovst_snpsht_hdr
1132: where snapshot_id = c_snapshot_id;
1133: dates_rec get_dates%ROWTYPE;
1134:
1135:

Line 1915: FROM ahl_autovst_snpsht_hdr WHERE snapshot_id = p_snapshot_id;

1911: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
1912:
1913: SELECT create_visit_flag, add_planned_reqs_flag, cancel_visit_flag
1914: INTO l_create_visit_flag, l_add_planned_reqs_flag, l_cancel_visit_flag
1915: FROM ahl_autovst_snpsht_hdr WHERE snapshot_id = p_snapshot_id;
1916:
1917: fnd_file.put_line(fnd_file.log, 'l_create_visit_flag -> '|| l_create_visit_flag);
1918: fnd_file.put_line(fnd_file.log, 'l_add_planned_reqs_flag -> '|| l_add_planned_reqs_flag);
1919: fnd_file.put_line(fnd_file.log, 'l_cancel_visit_flag -> '|| l_cancel_visit_flag);