APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 160: l_org HR_ALL_ORGANIZATION_UNITS.name%type;

156: l_visit_num NUMBER;
157: l_visit_type fnd_lookup_values_vl.meaning%type;
158: l_item MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
159: l_serial_number CSI_ITEM_INSTANCES.serial_number%type;
160: l_org HR_ALL_ORGANIZATION_UNITS.name%type;
161: l_dept BOM_DEPARTMENTS.description%type;
162: l_unit ahl_unit_config_headers.name%type;
163:
164: BEGIN

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

173: l_sql_string := l_sql_string || ' AHL_UTILITY_PVT.GET_UNIT_NAME(VST.ITEM_INSTANCE_ID) UNIT_NAME ';
174:
175: l_sql_string := l_sql_string || ' FROM ahl_visits_b vst, AHL_SIMULATION_PLANS_B ASML, ';
176: l_sql_string := l_sql_string || ' fnd_lookup_values_vl fndvt, MTL_SYSTEM_ITEMS_KFV MTSB, ';
177: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU, ';
178: l_sql_string := l_sql_string || ' BOM_DEPARTMENTS BDPT ';
179:
180: l_sql_string := l_sql_string || ' WHERE vst.simulation_plan_id = asml.simulation_plan_id AND ';
181: l_sql_string := l_sql_string || ' ASML.PRIMARY_PLAN_FLAG = ''Y'' AND ';