APPS.AHL_UA_COMMON_PVT dependencies on AHL_VISITS_B

Line 90: from ahl_visits_b vwp, ahl_unit_config_headers uc

86: vwp.visit_id event_id,
87: G_EVENT_TYPE_VISIT event_type,
88: vwp.start_date_time event_start_time,
89: AHL_VWP_TIMES_PVT.GET_VISIT_END_TIME(vwp.VISIT_ID , FND_API.G_FALSE) event_end_time
90: from ahl_visits_b vwp, ahl_unit_config_headers uc
91: where uc.unit_config_header_id = p_unit_config_id
92: and vwp.item_instance_id = uc.csi_item_instance_id
93: --priyan Bug # 5303188
94: and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) IN ('COMPLETE', 'INCOMPLETE')

Line 163: from ahl_visits_b vwp, ahl_unit_config_headers uc

159: vwp.visit_id event_id,
160: G_EVENT_TYPE_VISIT event_type,
161: vwp.start_date_time event_start_time,
162: AHL_VWP_TIMES_PVT.GET_VISIT_END_TIME(vwp.VISIT_ID , FND_API.G_FALSE) event_end_time
163: from ahl_visits_b vwp, ahl_unit_config_headers uc
164: where uc.unit_config_header_id = p_unit_config_id
165: and vwp.item_instance_id = uc.csi_item_instance_id
166: --priyan Bug # 5303188
167: and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) IN ('COMPLETE', 'INCOMPLETE')

Line 748: FROM AHL_VISITS_B VB,

744: SELECT
745: RANK () OVER (order by VB.START_DATE_TIME DESC) rank_value,
746: VB.VISIT_ID,
747: VB.START_DATE_TIME
748: FROM AHL_VISITS_B VB,
749: AHL_UNIT_CONFIG_HEADERS UC
750: WHERE
751: VB.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID AND
752: UC.UNIT_CONFIG_HEADER_ID = c_unit_config_id AND

Line 800: FROM AHL_VISITS_B VB,

796: VB.ATTRIBUTE13,
797: VB.ATTRIBUTE14,
798: VB.ATTRIBUTE15,
799: VB.UNIT_SCHEDULE_ID
800: FROM AHL_VISITS_B VB,
801: AHL_UNIT_CONFIG_HEADERS UC,
802: HR_ALL_ORGANIZATION_UNITS HROU,
803: BOM_DEPARTMENTS BDPT
804: WHERE

Line 867: AHL_VISITS_B VB,

863: HROU.NAME ORGANIZATION_NAME,
864: BDPT.DESCRIPTION DEPARTMENT_NAME,
865: VB.*
866: FROM
867: AHL_VISITS_B VB,
868: AHL_UNIT_CONFIG_HEADERS UC,
869: HR_ALL_ORGANIZATION_UNITS HROU,
870: BOM_DEPARTMENTS BDPT
871: WHERE

Line 1120: FROM AHL_VISITS_B VB,

1116: SELECT
1117: RANK () OVER (order by VB.START_DATE_TIME ASC) rank_value,
1118: VB.VISIT_ID,
1119: VB.START_DATE_TIME
1120: FROM AHL_VISITS_B VB,
1121: AHL_UNIT_CONFIG_HEADERS UC
1122: WHERE
1123: VB.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID AND
1124: UC.UNIT_CONFIG_HEADER_ID = c_unit_config_id AND

Line 1171: FROM AHL_VISITS_B VB,

1167: VB.ATTRIBUTE13,
1168: VB.ATTRIBUTE14,
1169: VB.ATTRIBUTE15,
1170: VB.UNIT_SCHEDULE_ID
1171: FROM AHL_VISITS_B VB,
1172: AHL_UNIT_CONFIG_HEADERS UC,
1173: HR_ALL_ORGANIZATION_UNITS HROU,
1174: BOM_DEPARTMENTS BDPT
1175: WHERE

Line 1235: AHL_VISITS_B VB,

1231: HROU.NAME ORGANIZATION_NAME,
1232: BDPT.DESCRIPTION DEPARTMENT_NAME,
1233: VB.*
1234: FROM
1235: AHL_VISITS_B VB,
1236: AHL_UNIT_CONFIG_HEADERS UC,
1237: HR_ALL_ORGANIZATION_UNITS HROU,
1238: BOM_DEPARTMENTS BDPT
1239: WHERE