2055: end;
2056:
2057: function GET_PATEO_ORGANIZATION_NAME(p_organization_id in number) return varchar2 is
2058: cursor c1 is select name
2059: from pa_organizations_expend_v
2060: where organization_id = p_organization_id;
2061: l_name pa_organizations_expend_v.name%type;
2062: begin
2063: if p_organization_id is not null then
2057: function GET_PATEO_ORGANIZATION_NAME(p_organization_id in number) return varchar2 is
2058: cursor c1 is select name
2059: from pa_organizations_expend_v
2060: where organization_id = p_organization_id;
2061: l_name pa_organizations_expend_v.name%type;
2062: begin
2063: if p_organization_id is not null then
2064: open c1;
2065: fetch c1 into l_name;