APPS.HZ_MATCH_RULE_PRIMARY_PKG dependencies on DUAL

Line 17: CURSOR C2 IS SELECT HZ_MATCH_RULE_PRIMARY_s.nextval FROM sys.dual;

13: p_LAST_UPDATED_BY NUMBER,
14: p_OBJECT_VERSION_NUMBER NUMBER,
15: p_DISPLAY_ORDER NUMBER DEFAULT NULL)
16: IS
17: CURSOR C2 IS SELECT HZ_MATCH_RULE_PRIMARY_s.nextval FROM sys.dual;
18: l_success VARCHAR2(1);
19: BEGIN
20: l_success := 'N';
21: WHILE l_success = 'N' LOOP

Line 66: into px_PRIMARY_ATTRIBUTE_ID FROM sys.dual;

62: BEGIN
63: l_count := 1;
64: WHILE l_count > 0 LOOP
65: SELECT HZ_MATCH_RULE_PRIMARY_s.nextval
66: into px_PRIMARY_ATTRIBUTE_ID FROM sys.dual;
67: BEGIN
68: SELECT 'Y' INTO l_dummy
69: FROM HZ_MATCH_RULE_PRIMARY
70: WHERE PRIMARY_ATTRIBUTE_ID = px_PRIMARY_ATTRIBUTE_ID;