APPS.HZ_PRIMARY_TRANSFORM_PKG dependencies on DUAL

Line 18: CURSOR C2 IS SELECT HZ_PRIMARY_TRANS_s.nextval FROM sys.dual;

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

Line 63: into px_PRIMARY_TRANSFORM_ID FROM sys.dual;

59: BEGIN
60: l_count := 1;
61: WHILE l_count > 0 LOOP
62: SELECT HZ_PRIMARY_TRANS_s.nextval
63: into px_PRIMARY_TRANSFORM_ID FROM sys.dual;
64: BEGIN
65: SELECT 'Y' INTO l_dummy
66: FROM HZ_PRIMARY_TRANS
67: WHERE PRIMARY_TRANSFORM_ID = px_PRIMARY_TRANSFORM_ID ;