APPS.HZ_MATCH_RULES_PKG dependencies on DUAL

Line 28: CURSOR C2 IS SELECT HZ_MATCH_RULES_s.nextval FROM sys.dual;

24: X_USE_CONTACT_CPT_FLAG IN VARCHAR2 DEFAULT NULL
25:
26: ) is
27:
28: CURSOR C2 IS SELECT HZ_MATCH_RULES_s.nextval FROM sys.dual;
29: l_success VARCHAR2(1) := 'N';
30: BEGIN
31: WHILE l_success = 'N' LOOP
32: BEGIN

Line 90: into X_MATCH_RULE_ID FROM sys.dual;

86: BEGIN
87: l_count := 1;
88: WHILE l_count > 0 LOOP
89: SELECT HZ_MATCH_RULES_s.nextval
90: into X_MATCH_RULE_ID FROM sys.dual;
91: BEGIN
92: SELECT 'Y' INTO l_dummy
93: FROM HZ_MATCH_RULES_B
94: WHERE MATCH_RULE_ID = X_MATCH_RULE_ID;