72: END BeforeReportTrigger;
73:
74: -- get Legal entity name
75: FUNCTION get_le_name(p_le_id IN NUMBER) RETURN VARCHAR2 IS
76: l_le_name gmf_legal_entities.legal_entity_name%TYPE :='';
77:
78: BEGIN
79: SELECT legal_entity_name INTO l_le_name FROM gmf_legal_entities
80: WHERE legal_entity_id = p_le_id;
75: FUNCTION get_le_name(p_le_id IN NUMBER) RETURN VARCHAR2 IS
76: l_le_name gmf_legal_entities.legal_entity_name%TYPE :='';
77:
78: BEGIN
79: SELECT legal_entity_name INTO l_le_name FROM gmf_legal_entities
80: WHERE legal_entity_id = p_le_id;
81:
82: RETURN l_le_name;
83: