APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 193: l_org HR_ALL_ORGANIZATION_UNITS.name%type;

189: l_visit_num NUMBER;
190: l_visit_type fnd_lookup_values_vl.meaning%type;
191: l_item MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
192: l_serial_number CSI_ITEM_INSTANCES.serial_number%type;
193: l_org HR_ALL_ORGANIZATION_UNITS.name%type;
194: l_dept BOM_DEPARTMENTS.description%type;
195: l_unit ahl_unit_config_headers.name%type;
196:
197: BEGIN

Line 210: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU, ';

206: l_sql_string := l_sql_string || ' AHL_UTILITY_PVT.GET_UNIT_NAME(VST.ITEM_INSTANCE_ID) UNIT_NAME ';
207:
208: l_sql_string := l_sql_string || ' FROM ahl_visits_b vst, AHL_SIMULATION_PLANS_B ASML, ';
209: l_sql_string := l_sql_string || ' fnd_lookup_values_vl fndvt, MTL_SYSTEM_ITEMS_KFV MTSB, ';
210: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU, ';
211: l_sql_string := l_sql_string || ' BOM_DEPARTMENTS BDPT ';
212:
213: l_sql_string := l_sql_string || ' WHERE vst.simulation_plan_id = asml.simulation_plan_id AND ';
214: l_sql_string := l_sql_string || ' ASML.PRIMARY_PLAN_FLAG = ''Y'' AND ';