121: */
122:
123: FUNCTION get_le_name(p_le_id IN NUMBER) RETURN VARCHAR2 IS
124:
125: l_le_name gmf_legal_entities.legal_entity_name%TYPE :='';
126:
127: BEGIN
128: -- get Legal entity name
129: SELECT legal_entity_name INTO l_le_name FROM gmf_legal_entities
125: l_le_name gmf_legal_entities.legal_entity_name%TYPE :='';
126:
127: BEGIN
128: -- get Legal entity name
129: SELECT legal_entity_name INTO l_le_name FROM gmf_legal_entities
130: WHERE legal_entity_id = p_le_id;
131:
132: RETURN l_le_name;
133:
155: REM+=========================================================================+
156: */
157: FUNCTION get_currency(p_le_id IN NUMBER) RETURN VARCHAR2 IS
158:
159: l_currency gmf_legal_entities.base_currency_code%TYPE :='';
160:
161: BEGIN
162: SELECT base_currency_code INTO l_currency FROM gmf_legal_entities
163: WHERE legal_entity_id = p_le_id;
158:
159: l_currency gmf_legal_entities.base_currency_code%TYPE :='';
160:
161: BEGIN
162: SELECT base_currency_code INTO l_currency FROM gmf_legal_entities
163: WHERE legal_entity_id = p_le_id;
164:
165: RETURN l_currency;
166: