APPS.AHL_AVF_PRIM_VSTS_PVT dependencies on AHL_AUTOVISIT_HIERARCHY

Line 176: FROM ahl_autovisit_hierarchy

172:
173: -- Get the MC_IDs for the given Snapshot
174: CURSOR get_mc_ids(c_snapshot_id in NUMBER) IS
175: SELECT mc_id
176: FROM ahl_autovisit_hierarchy
177: WHERE autovisit_flag = 'Y'
178: AND snapshot_id = c_snapshot_id
179: AND hierarchy_type_code = L_MASTER_CODE;
180:

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 1093: FROM ahl_autovisit_hierarchy

1089:
1090: Cursor get_mc_ids (c_snapshot_id IN NUMBER)
1091: IS
1092: SELECT MC_ID
1093: FROM ahl_autovisit_hierarchy
1094: WHERE HIERARCHY_TYPE_CODE = 'MASTER_CONFIGURATION'
1095: AND SNAPSHOT_ID = c_snapshot_id
1096: AND AUTOVISIT_FLAG = 'Y'
1097: ORDER BY SEQUENCE;

Line 1102: FROM ahl_autovisit_hierarchy

1098:
1099: Cursor get_program_type_code (c_snapshot_id IN NUMBER)
1100: IS
1101: SELECT PROGRAM_TYPE_CODE
1102: FROM ahl_autovisit_hierarchy
1103: WHERE HIERARCHY_TYPE_CODE = 'PROGRAM'
1104: AND SNAPSHOT_ID = c_snapshot_id
1105: AND AUTOVISIT_FLAG = 'Y'
1106: ORDER BY SEQUENCE;

Line 1111: FROM ahl_autovisit_hierarchy

1107:
1108: Cursor get_prog_subtyp_code (c_snapshot_id IN NUMBER, c_prog_typ_code IN VARCHAR2)
1109: IS
1110: SELECT PROGRAM_SUBTYPE_CODE
1111: FROM ahl_autovisit_hierarchy
1112: WHERE HIERARCHY_TYPE_CODE = 'SUBTYPE'
1113: AND PROGRAM_TYPE_CODE = c_prog_typ_code
1114: AND SNAPSHOT_ID = c_snapshot_id
1115: AND AUTOVISIT_FLAG = 'Y'

Line 1121: FROM ahl_autovisit_hierarchy

1117:
1118: Cursor get_count_prog_subtyp (c_snapshot_id IN NUMBER, c_prog_typ_code IN VARCHAR2)
1119: IS
1120: SELECT count(PROGRAM_SUBTYPE_CODE)
1121: FROM ahl_autovisit_hierarchy
1122: WHERE HIERARCHY_TYPE_CODE = 'SUBTYPE'
1123: AND PROGRAM_TYPE_CODE = c_prog_typ_code
1124: AND SNAPSHOT_ID = c_snapshot_id
1125: AND AUTOVISIT_FLAG = 'Y';