APPS.AHL_VWP_VISITS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1033: -- AnRaj: Replaced HR_ALL_ORGANIZATION_UNITS with HR_ALL_ORGANIZATION_UNITS_TL, Fix for Bug# 5367598

1029: AND AVTS.SERVICE_REQUEST_ID = CSAB.INCIDENT_ID(+)
1030: AND AVTS.TEMPLATE_FLAG = 'N' AND AVTS.STATUS_CODE <> 'DELETED'
1031: AND UC.active_end_date is null
1032: AND VISIT_ID = x_id;*/
1033: -- AnRaj: Replaced HR_ALL_ORGANIZATION_UNITS with HR_ALL_ORGANIZATION_UNITS_TL, Fix for Bug# 5367598
1034: SELECT AVTS.VISIT_ID , AVTS.VISIT_NUMBER,
1035: AVTSTL.VISIT_NAME,AVTS.ORGANIZATION_ID ,
1036: AVTS.START_DATE_TIME, AVTS.CLOSE_DATE_TIME,AVTS.VISIT_TYPE_CODE ,
1037: AVTS.DEPARTMENT_ID ,AVTS.STATUS_CODE,AVTS.OBJECT_VERSION_NUMBER,

Line 1056: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,

1052: ,PA.NAME PROJECT_TEMPLATE_NAME,
1053: AVTS.INV_LOCATOR_ID -- Added by sowsubra
1054: FROM AHL_VISITS_B AVTS,AHL_VISITS_TL AVTSTL,
1055: AHL_SIMULATION_PLANS_B ASPV,AHL_SIMULATION_PLANS_TL ASPVTL,
1056: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,
1057: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1058: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,
1059: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,
1060: PA_PROJECTS_ALL PA,