APPS.GHR_SF52_POST_UPDATE dependencies on DUAL

Line 35: select ghr_pa_notifications_s.nextval from sys.dual;

31: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
32: l_object_version_number ghr_pa_requests.object_version_number%type;
33:
34: Cursor C_Sel1 is
35: select ghr_pa_notifications_s.nextval from sys.dual;
36:
37: -- Get all data pertaining to Notifications
38:
39: begin

Line 184: select ghr_pa_notifications_s.nextval from sys.dual;

180: l_person_id ghr_pa_requests.person_id%type;
181: l_exists boolean;
182:
183: Cursor C_Sel1 is
184: select ghr_pa_notifications_s.nextval from sys.dual;
185:
186: Cursor C_person is
187: select par.person_id,
188: par.employee_assignment_id