APPS.AMS_LIST_RULES_PKG dependencies on DUAL

Line 252: FROM DUAL;

248: WHERE list_rule_id = x_list_rule_id;
249:
250: CURSOR c_get_id is
251: SELECT ams_list_rules_all_s.NEXTVAL
252: FROM DUAL;
253: BEGIN
254: if X_OWNER = 'SEED' then
255: l_user_id := 1;
256: elsif X_OWNER = 'ORACLE' then

Line 568: FROM DUAL;

564: AND LAST_UPDATED_BY <> 1 and last_updated_by <> 2 and last_updated_by <> 0;
565:
566: CURSOR c_get_id is
567: SELECT ams_list_rule_fields_s.NEXTVAL
568: FROM DUAL;
569: l_dummy_rule_char varchar2(1);
570: BEGIN
571: if X_OWNER = 'SEED' then
572: l_user_id := 1;