APPS.GHR_WGI_PKG dependencies on FND_SESSIONS

Line 302: CURSOR c_fnd_sessions

298: )
299: )
300: AND proc_method_flag = 'Y';
301:
302: CURSOR c_fnd_sessions
303: IS
304: SELECT 1
305: FROM fnd_sessions
306: WHERE session_id = USERENV ('sessionid');

Line 305: FROM fnd_sessions

301:
302: CURSOR c_fnd_sessions
303: IS
304: SELECT 1
305: FROM fnd_sessions
306: WHERE session_id = USERENV ('sessionid');
307:
308: CURSOR cur_wgi_no_payplan (p_grd_id per_grades.grade_id%TYPE)
309: IS

Line 350: -- The previous code did not perform a commit after writing to fnd_sessions

346:
347: dt_fndate.change_ses_date (p_ses_date => TRUNC (SYSDATE),
348: p_commit => l_commit
349: );
350: -- The previous code did not perform a commit after writing to fnd_sessions
351: -- Hence not issuing a Commit based on the value of the l_commit out variable
352:
353: hr_utility.set_location('Before Check if Personnel Office ID is having group box',1234);
354: -- Bug 3649933. Check if Personnel Office ID is having group box