APPS.AMS_DM_MODEL_PVT dependencies on DUAL

Line 533: FROM DUAL;

529: l_access_rec AMS_Access_PVT.access_rec_type;
530:
531: CURSOR c_dm_model_seq IS
532: SELECT ams_dm_models_all_b_s.NEXTVAL
533: FROM DUAL;
534:
535: CURSOR c_dm_model_count(p_model_id IN NUMBER) IS
536: SELECT 1
537: FROM ams_dm_models_vl

Line 1718: IS SELECT 1 from dual

1714: IS
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

Line 1722: IS SELECT 1 from dual

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
1724: WHERE UPPER(model_name) = UPPER(p_dm_model_rec.model_name)
1725: AND model_id <> p_DM_MODEL_rec.model_id );
1726: