APPS.AMS_DM_TARGET_PVT dependencies on DUAL

Line 64: FROM dual;

60: l_dm_target_rec AMS_DM_TARGET_PVT.dm_target_rec_type := p_dm_target_rec;
61:
62: CURSOR c_id IS
63: SELECT AMS_DM_TARGETS_B_s.NEXTVAL
64: FROM dual;
65:
66: CURSOR c_id_exists (l_id IN NUMBER) IS
67: SELECT 1
68: FROM AMS_DM_TARGETS_VL

Line 881: IS SELECT 1 from dual

877: l_valid_flag VARCHAR2(1);
878: l_number NUMBER;
879:
880: CURSOR c_target_name
881: IS SELECT 1 from dual
882: WHERE EXISTS ( SELECT * from ams_dm_targets_vl
883: WHERE UPPER(target_name) = UPPER(p_dm_target_rec.target_name)) ;
884: CURSOR c_target_name_updt
885: IS SELECT 1 from dual

Line 885: IS SELECT 1 from dual

881: IS SELECT 1 from dual
882: WHERE EXISTS ( SELECT * from ams_dm_targets_vl
883: WHERE UPPER(target_name) = UPPER(p_dm_target_rec.target_name)) ;
884: CURSOR c_target_name_updt
885: IS SELECT 1 from dual
886: WHERE EXISTS ( SELECT * from ams_dm_targets_vl
887: WHERE UPPER(target_name) = UPPER(p_dm_target_rec.target_name)
888: AND target_id <> p_dm_target_rec.target_id );
889: