APPS.AMS_SETUP_ATTR_PVT dependencies on DUAL

Line 41: FROM DUAL;

37: l_setup_attr_count NUMBER;
38:
39: CURSOR c_setup_attr_seq IS
40: SELECT AMS_CUSTOM_SETUP_ATTR_S.NEXTVAL
41: FROM DUAL;
42:
43: CURSOR c_setup_attr_count(setup_attr_id IN NUMBER) IS
44: SELECT COUNT(*)
45: FROM AMS_CUSTOM_SETUP_ATTR

Line 732: SELECT 1 FROM dual

728: l_uk_flag VARCHAR2(1);
729: l_dummy NUMBER;
730:
731: CURSOR c_ess_seq_exists(seq_num_in IN NUMBER, id_in IN NUMBER, setup_id_in IN NUMBER) IS
732: SELECT 1 FROM dual
733: WHERE EXISTS (SELECT 1 FROM ams_custom_setup_attr
734: WHERE custom_setup_id = id_in
735: AND essential_seq_num = seq_num_in
736: AND setup_attribute_id <> setup_id_in