142: SELECT
143: ORGANIZATION_CODE
144: INTO COMMON_ORG
145: FROM
146: ORG_ORGANIZATION_DEFINITIONS
147: WHERE ORGANIZATION_ID = COMMON_ORGANIZATION_ID;
148: END IF;
149: RETURN (COMMON_ORG);
150: END GET_COMMON_ORG;
155: SELECT
156: ORGANIZATION_CODE
157: INTO ORG_CODE
158: FROM
159: ORG_ORGANIZATION_DEFINITIONS ORG
160: WHERE ORG.ORGANIZATION_ID = ORG_ID;
161: RETURN (ORG_CODE);
162: END ORG_CODEFORMULA;
163: