249: CURSOR CUR_LEGAL_ENTITY_NAME IS
250: SELECT
251: LEGAL_ENTITY_NAME
252: FROM
253: GMF_LEGAL_ENTITIES
254: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;
255: L_LEGAL_ENTITY_NAME GMF_LEGAL_ENTITIES.LEGAL_ENTITY_NAME%TYPE;
256: BEGIN
257: OPEN CUR_LEGAL_ENTITY_NAME;
251: LEGAL_ENTITY_NAME
252: FROM
253: GMF_LEGAL_ENTITIES
254: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;
255: L_LEGAL_ENTITY_NAME GMF_LEGAL_ENTITIES.LEGAL_ENTITY_NAME%TYPE;
256: BEGIN
257: OPEN CUR_LEGAL_ENTITY_NAME;
258: FETCH CUR_LEGAL_ENTITY_NAME
259: INTO L_LEGAL_ENTITY_NAME;