[Home] [Help]
2622:
2623:
2624: SELECT COUNT(*)
2625: INTO l_le_count
2626: FROM XLE_FP_OU_LEDGER_V
2627: where OPERATING_UNIT_ID = nvl(fnd_profile.value_wnps('ORG_ID'),-99);
2628:
2629: IF (l_le_count = 1) THEN
2630: SELECT legal_entity_name
2628:
2629: IF (l_le_count = 1) THEN
2630: SELECT legal_entity_name
2631: INTO l_legal_entity_name
2632: FROM XLE_FP_OU_LEDGER_V
2633: WHERE OPERATING_UNIT_ID = nvl(fnd_profile.value_wnps('ORG_ID'),-99);
2634: ELSE
2635: BEGIN
2636: SELECT NAME