DBA Data[Home] [Help]

APPS.XLE_UTILITIES_GRP dependencies on FND_PROFILE

Line 2629: where OPERATING_UNIT_ID = nvl(fnd_profile.value_wnps('ORG_ID'),-99);

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

Line 2635: WHERE OPERATING_UNIT_ID = nvl(fnd_profile.value_wnps('ORG_ID'),-99);

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

Line 2641: WHERE LEGAL_ENTITY_ID = Get_DefaultLegalContext_OU(fnd_profile.value_wnps('ORG_ID'));

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;