APPS.HZ_SECONDARY_TRANSFORM_PKG dependencies on DUAL

Line 20: CURSOR C2 IS SELECT HZ_SECONDARY_TRANS_S.nextval FROM sys.dual;

16: p_LAST_UPDATE_DATE DATE,
17: p_LAST_UPDATED_BY NUMBER,
18: p_OBJECT_VERSION_NUMBER NUMBER)
19: IS
20: CURSOR C2 IS SELECT HZ_SECONDARY_TRANS_S.nextval FROM sys.dual;
21: l_success VARCHAR2(1) := 'N';
22: BEGIN
23: WHILE l_success = 'N' LOOP
24: BEGIN

Line 72: into px_SECONDARY_TRANSFORM_ID FROM sys.dual;

68: BEGIN
69: l_count := 1;
70: WHILE l_count > 0 LOOP
71: SELECT HZ_MATCH_RULE_SECONDARY_s.nextval
72: into px_SECONDARY_TRANSFORM_ID FROM sys.dual;
73: BEGIN
74: SELECT 'Y' INTO l_dummy
75: FROM HZ_MATCH_RULE_SECONDARY
76: WHERE SECONDARY_ATTRIBUTE_ID = px_SECONDARY_TRANSFORM_ID ;