APPS.HZ_TRANS_FUNCTIONS_PKG dependencies on DUAL

Line 25: CURSOR C2 IS SELECT HZ_TRANS_FUNCTIONS_s.nextval FROM sys.dual;

21: X_LAST_UPDATED_BY in NUMBER,
22: X_LAST_UPDATE_LOGIN in NUMBER,
23: X_OBJECT_VERSION_NUMBER in NUMBER
24: ) is
25: CURSOR C2 IS SELECT HZ_TRANS_FUNCTIONS_s.nextval FROM sys.dual;
26: l_success VARCHAR2(1) := 'N';
27: l_staged_attribute_column varchar2(255);
28: begin
29: l_staged_attribute_column := get_valid_tx_column(X_STAGED_ATTRIBUTE_TABLE,X_STAGED_ATTRIBUTE_COLUMN);

Line 82: into X_FUNCTION_ID FROM sys.dual;

78: BEGIN
79: l_count := 1;
80: WHILE l_count > 0 LOOP
81: SELECT HZ_TRANS_FUNCTIONS_s.nextval
82: into X_FUNCTION_ID FROM sys.dual;
83: BEGIN
84: SELECT 'Y' INTO l_dummy
85: FROM HZ_TRANS_FUNCTIONS_B
86: WHERE FUNCTION_ID = X_FUNCTION_ID;