266:
267: BEGIN
268: begin
269: select oracle_username into l_b_schema
270: from fnd_oracle_userid
271: where oracle_id = X_B_SCHEMA;
272: exception
273: when others then
274: l_b_schema := x_B_SCHEMA;
334: BEGIN
335:
336: begin
337: select oracle_username into l_b_schema
338: from fnd_oracle_userid
339: where oracle_id = X_B_SCHEMA;
340: exception
341: when others then
342: l_b_schema := x_B_SCHEMA;