DBA Data[Home] [Help]

APPS.CZ_MODELOPERATIONS_PUB dependencies on CZ_MODEL_USAGES

Line 1997: FROM CZ_MODEL_USAGES

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

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

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

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

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