APPS.HZ_MATCH_RULE_SECONDARY_PKG dependencies on HZ_MATCH_RULE_SECONDARY_S

Line 17: CURSOR C2 IS SELECT HZ_MATCH_RULE_SECONDARY_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_SECONDARY_s.nextval FROM sys.dual;
18: l_success VARCHAR2(1) ;
19:
20: BEGIN
21: l_success := 'N';

Line 68: SELECT HZ_MATCH_RULE_SECONDARY_s.nextval

64: l_dummy VARCHAR2(1);
65: BEGIN
66: l_count := 1;
67: WHILE l_count > 0 LOOP
68: SELECT HZ_MATCH_RULE_SECONDARY_s.nextval
69: into px_SECONDARY_ATTRIBUTE_ID FROM sys.dual;
70: BEGIN
71: SELECT 'Y' INTO l_dummy
72: FROM HZ_MATCH_RULE_SECONDARY