DBA Data[Home] [Help]

APPS.PER_LETTER_REQUESTS_PKG dependencies on DUAL

Line 113: CURSOR C2 IS SELECT per_letter_requests_s.nextval FROM sys.dual;

109: ) IS
110: CURSOR C IS SELECT rowid FROM per_letter_requests
111: WHERE letter_request_id = X_Letter_Request_Id;
112: --
113: CURSOR C2 IS SELECT per_letter_requests_s.nextval FROM sys.dual;
114: BEGIN
115: if (X_Letter_Request_Id is NULL) then
116: OPEN C2;
117: FETCH C2 INTO X_Letter_Request_Id;