DBA Data[Home] [Help]

APPS.GMF_CBOM_REP_PKG dependencies on GMF_LEGAL_ENTITIES

Line 125: l_le_name gmf_legal_entities.legal_entity_name%TYPE :='';

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

Line 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:

Line 159: l_currency gmf_legal_entities.base_currency_code%TYPE :='';

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;

Line 162: SELECT base_currency_code INTO l_currency FROM gmf_legal_entities

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: