119: FROM fnd_languages
120: WHERE installed_flag = 'B';
121:
122: /* For bug 2113775
123: Selecting the organization from gl_sets_of_books
124: in case of single org since the org_id will be
125: null in hr_organization_units*/
126: BEGIN
127:
134: WHEN no_data_found THEN
135: BEGIN
136: SELECT name
137: INTO l_organization_name
138: FROM gl_sets_of_books
139: WHERE set_of_books_id = P_Set_of_books_id;
140: EXCEPTION
141: WHEN OTHERS THEN
142: NULL;