DBA Data[Home] [Help]

APPS.CZ_MODELOPERATIONS_PUB dependencies on CZ_MODEL_USAGES

Line 2001: FROM CZ_MODEL_USAGES

1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1998: END IF;
1999: SELECT model_usage_id
2000: INTO v_usage_id
2001: FROM CZ_MODEL_USAGES
2002: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
2003: AND cz_model_usages.in_use = '1';
2004:
2005: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2002: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))

1998: END IF;
1999: SELECT model_usage_id
2000: INTO v_usage_id
2001: FROM CZ_MODEL_USAGES
2002: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
2003: AND cz_model_usages.in_use = '1';
2004:
2005: x_return_status := FND_API.G_RET_STS_SUCCESS;
2006: RETURN v_usage_id;

Line 2003: AND cz_model_usages.in_use = '1';

1999: SELECT model_usage_id
2000: INTO v_usage_id
2001: FROM CZ_MODEL_USAGES
2002: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
2003: AND cz_model_usages.in_use = '1';
2004:
2005: x_return_status := FND_API.G_RET_STS_SUCCESS;
2006: RETURN v_usage_id;
2007: EXCEPTION