APPS.GMF_UTILITIES_GRP dependencies on GMF_LEGAL_ENTITIES

Line 98: SELECT chart_of_accounts_id INTO l_chart_of_accounts_id FROM gmf_legal_entities

94: ORDER BY f.segment_num;
95: l_seg_num t_seg_num;
96:
97: BEGIN
98: SELECT chart_of_accounts_id INTO l_chart_of_accounts_id FROM gmf_legal_entities
99: WHERE legal_entity_id = p_legal_entity_id;
100: l_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#', l_chart_of_accounts_id);
101: OPEN segments(l_chart_of_accounts_id);
102: FETCH segments bulk collect INTO l_seg_num;

Line 135: CURSOR cp_legal_entity (cp_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE) IS

131:
132: FUNCTION get_legal_entity(p_legal_entity_id IN NUMBER)
133: RETURN VARCHAR2 IS
134:
135: CURSOR cp_legal_entity (cp_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE) IS
136: SELECT legal_entity_name FROM gmf_legal_entities
137: WHERE legal_entity_id = cp_legal_entity_id;
138:
139: l_legal_entity_name gmf_legal_entities.legal_entity_name%TYPE := NULL;

Line 136: SELECT legal_entity_name FROM gmf_legal_entities

132: FUNCTION get_legal_entity(p_legal_entity_id IN NUMBER)
133: RETURN VARCHAR2 IS
134:
135: CURSOR cp_legal_entity (cp_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE) IS
136: SELECT legal_entity_name FROM gmf_legal_entities
137: WHERE legal_entity_id = cp_legal_entity_id;
138:
139: l_legal_entity_name gmf_legal_entities.legal_entity_name%TYPE := NULL;
140:

Line 139: l_legal_entity_name gmf_legal_entities.legal_entity_name%TYPE := NULL;

135: CURSOR cp_legal_entity (cp_legal_entity_id gmf_legal_entities.legal_entity_id%TYPE) IS
136: SELECT legal_entity_name FROM gmf_legal_entities
137: WHERE legal_entity_id = cp_legal_entity_id;
138:
139: l_legal_entity_name gmf_legal_entities.legal_entity_name%TYPE := NULL;
140:
141: BEGIN
142: OPEN cp_legal_entity(p_legal_entity_id);
143: FETCH cp_legal_entity INTO l_legal_entity_name;

Line 271: SELECT chart_of_accounts_id INTO l_chart_of_accounts_id FROM gmf_legal_entities

267: close cur_description;
268: return l_description;
269: end description;
270: BEGIN
271: SELECT chart_of_accounts_id INTO l_chart_of_accounts_id FROM gmf_legal_entities
272: WHERE legal_entity_id = p_legal_entity_id;
273: l_delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#', l_chart_of_accounts_id);
274: n := lengthb(p_account_key) - lengthb(replace(p_account_key, l_delimiter,null));
275: for i in 1..n+1 loop