325: X_org_encumbrance_account,
326: X_org_sales_account,
327: X_org_expense_account,
328: X_master_org_name
329: from mtl_parameters mp, hr_organization_units hr
330: where mp.organization_id = master_org
331: and mp.organization_id = hr.organization_id;
332:
333: -- Get this info for the current org
765: if (X_default_shipping_org is not null) then
766: begin
767: select name
768: into X_default_shipping_org_dsp
769: from hr_organization_units
770: where organization_id = X_default_shipping_org;
771: exception
772: when NO_DATA_FOUND then
773: X_default_shipping_org_dsp := null;
821: if (X_source_organization_id is not null) then
822: begin
823: select mp.organization_code,hou.name
824: into X_source_organization, X_source_org_name
825: from hr_organization_units hou
826: ,mtl_parameters mp
827: where hou.organization_id = mp.organization_id
828: and mp.organization_id = X_source_organization_id;
829: exception