APPS.HZ_TRANS_ATTRIBUTES_PKG dependencies on DUAL

Line 19: CURSOR C2 IS SELECT HZ_TRANS_ATTRIBUTES_s.nextval FROM sys.dual;

15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER,
17: X_OBJECT_VERSION_NUMBER in NUMBER
18: ) is
19: CURSOR C2 IS SELECT HZ_TRANS_ATTRIBUTES_s.nextval FROM sys.dual;
20: l_success VARCHAR2(1) := 'N';
21: begin
22: WHILE l_success = 'N' LOOP
23: BEGIN

Line 68: into X_ATTRIBUTE_ID FROM sys.dual;

64: BEGIN
65: l_count := 1;
66: WHILE l_count > 0 LOOP
67: SELECT HZ_TRANS_ATTRIBUTES_s.nextval
68: into X_ATTRIBUTE_ID FROM sys.dual;
69: BEGIN
70: SELECT 'Y' INTO l_dummy
71: FROM HZ_TRANS_ATTRIBUTES_B
72: WHERE ATTRIBUTE_ID = X_ATTRIBUTE_ID;