DBA Data[Home] [Help]

APPS.CZ_CF_API dependencies on CZ_MODEL_USAGES

Line 84: FROM CZ_MODEL_USAGES

80: IF p_usage_name IS NOT NULL THEN
81: BEGIN
82: SELECT model_usage_id
83: INTO v_usage_id
84: FROM CZ_MODEL_USAGES
85: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
86: AND cz_model_usages.in_use = '1';
87: EXCEPTION
88: WHEN OTHERS THEN

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

81: BEGIN
82: SELECT model_usage_id
83: INTO v_usage_id
84: FROM CZ_MODEL_USAGES
85: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
86: AND cz_model_usages.in_use = '1';
87: EXCEPTION
88: WHEN OTHERS THEN
89: v_usage_id := ANY_USAGE_ID;

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

82: SELECT model_usage_id
83: INTO v_usage_id
84: FROM CZ_MODEL_USAGES
85: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
86: AND cz_model_usages.in_use = '1';
87: EXCEPTION
88: WHEN OTHERS THEN
89: v_usage_id := ANY_USAGE_ID;
90: END;