Line 1221: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then
1217:
1218: -- adding the session id check to avoid connection pooling problems.
1219: -- if (hr_process_person_ss.g_assignment_id is not null) then
1220: if (( hr_process_person_ss.g_assignment_id is not null) and 1221: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then 1222: ln_selected_emp_id := hr_process_person_ss.g_person_id;
1223: ln_passed_assignment_id := hr_process_person_ss.g_assignment_id;
1224: end if;
1225: