2625:
2626: SELECT COUNT(*)
2627: INTO l_le_count
2628: FROM XLE_FP_OU_LEDGER_V
2629: where OPERATING_UNIT_ID = nvl(fnd_profile.value_wnps('ORG_ID'),-99);
2630:
2631: IF (l_le_count = 1) THEN
2632: SELECT legal_entity_name
2633: INTO l_legal_entity_name
2631: IF (l_le_count = 1) THEN
2632: SELECT legal_entity_name
2633: INTO l_legal_entity_name
2634: FROM XLE_FP_OU_LEDGER_V
2635: WHERE OPERATING_UNIT_ID = nvl(fnd_profile.value_wnps('ORG_ID'),-99);
2636: ELSE
2637: BEGIN
2638: SELECT NAME
2639: INTO l_legal_entity_name
2637: BEGIN
2638: SELECT NAME
2639: INTO l_legal_entity_name
2640: FROM XLE_FIRSTPARTY_INFORMATION_V
2641: WHERE LEGAL_ENTITY_ID = Get_DefaultLegalContext_OU(fnd_profile.value_wnps('ORG_ID'));
2642: EXCEPTION
2643: WHEN OTHERS THEN
2644: RETURN NULL;
2645: END;