DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 5267: FROM AHL_UNIT_EFFECTIVITIES_B A,

5263: trunc(VST.start_date_time) start_date_time,
5264: trunc(VST.CLOSE_DATE_TIME) close_date_time,
5265: (
5266: SELECT MAX(DUE_DATE)
5267: FROM AHL_UNIT_EFFECTIVITIES_B A,
5268: AHL_VISIT_TASKS_B B
5269: WHERE A.UNIT_EFFECTIVITY_ID = B.UNIT_EFFECTIVITY_ID
5270: AND B.VISIT_ID = VST.VISIT_ID
5271: GROUP BY VISIT_ID

Line 5304: FROM AHL_UNIT_EFFECTIVITIES_B A,

5300: trunc(VST.start_date_time) start_date_time,
5301: trunc(VST.CLOSE_DATE_TIME) close_date_time,
5302: (
5303: SELECT MAX(DUE_DATE)
5304: FROM AHL_UNIT_EFFECTIVITIES_B A,
5305: AHL_VISIT_TASKS_B B
5306: WHERE A.UNIT_EFFECTIVITY_ID = B.UNIT_EFFECTIVITY_ID
5307: AND B.VISIT_ID = VST.VISIT_ID
5308: GROUP BY VISIT_ID