APPS.AHL_VWP_VISITS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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

1212: AND AVTS.SERVICE_REQUEST_ID = CSAB.INCIDENT_ID(+)
1213: AND AVTS.TEMPLATE_FLAG = 'N' AND AVTS.STATUS_CODE <> 'DELETED'
1214: AND UC.active_end_date is null
1215: AND VISIT_ID = x_id;*/
1216: -- AnRaj: Replaced HR_ALL_ORGANIZATION_UNITS with HR_ALL_ORGANIZATION_UNITS_TL, Fix for Bug# 5367598
1217: SELECT AVTS.VISIT_ID , AVTS.VISIT_NUMBER,
1218: AVTSTL.VISIT_NAME,AVTS.ORGANIZATION_ID ,
1219: AVTS.START_DATE_TIME, AVTS.CLOSE_DATE_TIME,AVTS.VISIT_TYPE_CODE ,
1220: AVTS.DEPARTMENT_ID ,AVTS.STATUS_CODE,AVTS.OBJECT_VERSION_NUMBER,

Line 1242: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,

1238: AVTS.TOP_PROJECT_TASK_ID, --PRAKKUM ::FP PIE :: 13-OCT-2010
1239: AVTS.INV_LOCATOR_ID -- Added by sowsubra
1240: FROM AHL_VISITS_B AVTS,AHL_VISITS_TL AVTSTL,
1241: AHL_SIMULATION_PLANS_B ASPV,AHL_SIMULATION_PLANS_TL ASPVTL,
1242: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,
1243: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1244: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,
1245: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,
1246: -- SKPATHAK :: Bug #8983097 :: 20-OCT-2009