APPS.AMS_DM_MODEL_PVT dependencies on AMS_DM_MODELS_ALL_TL

Line 395: FROM ams_dm_models_all_tl

391: FOR UPDATE NOWAIT;
392:
393: CURSOR c_dm_model_tl IS
394: SELECT MODEL_ID
395: FROM ams_dm_models_all_tl
396: WHERE MODEL_ID = p_MODEL_ID
397: AND USERENV('LANG') IN (language, source_lang)
398: FOR UPDATE NOWAIT;
399:

Line 1719: WHERE EXISTS ( SELECT * from ams_dm_models_all_tl

1715: l_valid_flag VARCHAR2(1);
1716:
1717: CURSOR c_model_name
1718: IS SELECT 1 from dual
1719: WHERE EXISTS ( SELECT * from ams_dm_models_all_tl
1720: WHERE UPPER(model_name) = UPPER(p_dm_model_rec.model_name) and LANGUAGE = userenv('LANG')) ;
1721: CURSOR c_model_name_updt
1722: IS SELECT 1 from dual
1723: WHERE EXISTS ( SELECT * from ams_dm_models_vl