APPS.AHL_UA_COMMON_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

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 749: AHL_UNIT_CONFIG_HEADERS UC

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
753: VB.START_DATE_TIME < c_start_time AND

Line 801: AHL_UNIT_CONFIG_HEADERS UC,

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
805: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND

Line 868: AHL_UNIT_CONFIG_HEADERS UC,

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
872: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND

Line 1121: AHL_UNIT_CONFIG_HEADERS UC

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
1125: START_DATE_TIME > c_end_time AND

Line 1172: AHL_UNIT_CONFIG_HEADERS UC,

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
1176: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND

Line 1236: AHL_UNIT_CONFIG_HEADERS UC,

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
1240: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND