DBA Data[Home] [Help]

APPS.OTA_ADD_TRAINING_SS dependencies on DUAL

Line 2251: SELECT OTA_GENERAL.get_org_name(p_organization_id) INTO l_value FROM DUAL;

2247: BEGIN
2248: HR_UTILITY.SET_LOCATION('Entering:'||g_package||l_proc, 10);
2249:
2250: IF p_organization_id IS NOT NULL THEN
2251: SELECT OTA_GENERAL.get_org_name(p_organization_id) INTO l_value FROM DUAL;
2252: ELSE
2253: OPEN c_get_customer_name;
2254: FETCH c_get_customer_name INTO l_value;
2255: CLOSE c_get_customer_name;