DBA Data[Home] [Help]

APPS.XLE_UTILITIES_GRP dependencies on FND_PROFILE

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

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
2631: INTO l_legal_entity_name

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

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
2637: INTO l_legal_entity_name

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

2635: BEGIN
2636: SELECT NAME
2637: INTO l_legal_entity_name
2638: FROM XLE_FIRSTPARTY_INFORMATION_V
2639: WHERE LEGAL_ENTITY_ID = Get_DefaultLegalContext_OU(fnd_profile.value_wnps('ORG_ID'));
2640: EXCEPTION
2641: WHEN OTHERS THEN
2642: RETURN NULL;
2643: END;