253:
254: Select legal_entity_id
255: BULK COLLECT INTO
256: l_legal_entity_id
257: from xle_le_ou_ledger_v
258: where ledger_id = p_sob_id and
259: operating_unit_id = p_org_id;
260:
261: IF (l_legal_entity_id.COUNT = 1) THEN
311:
312: Select legal_entity_name
313: BULK COLLECT INTO
314: l_legal_entity_name
315: from xle_le_ou_ledger_v
316: where ledger_id = p_sob_id and
317: operating_unit_id = p_org_id;
318:
319: IF (l_legal_entity_name.COUNT = 1) THEN