DBA Data[Home] [Help]

APPS.CSP_REPAIR_ORDER_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 107: from hr_all_organization_units

103: BEGIN
104: IF (l_source_type = 'REPAIR') THEN
105: select name
106: into l_supplier_name
107: from hr_all_organization_units
108: where organization_id = l_Repair_supplier_id;
109: ELSE
110: select vendor_name
111: into l_supplier_name