240: --this function gets the organization_code from an org id
241: FUNCTION get_org_code_from_orgid(p_orgid IN NUMBER)
242: RETURN VARCHAR2
243: IS
244: x_orgcode mtl_parameters.organization_code%TYPE;
245: CURSOR C IS
246: SELECT organization_code
247: FROM mtl_parameters
248: WHERE organization_id = p_orgid;
243: IS
244: x_orgcode mtl_parameters.organization_code%TYPE;
245: CURSOR C IS
246: SELECT organization_code
247: FROM mtl_parameters
248: WHERE organization_id = p_orgid;
249: BEGIN
250: OPEN C;
251: FETCH C INTO x_orgcode;