APPS.PQH_WORKFLOW dependencies on FND_SESSIONS

Line 4652: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this

4648: hr_utility.set_location('user is '||l_user_name||l_proc,15);
4649: p_status_flag := null;
4650:
4651: --
4652: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
4653: -- record if one does not already exist.
4654: --
4655: begin
4656: SELECT effective_date

Line 4658: FROM fnd_sessions

4654: --
4655: begin
4656: SELECT effective_date
4657: INTO l_session_date
4658: FROM fnd_sessions
4659: WHERE session_id = userenv('sessionid');
4660: exception
4661: when others then
4662: insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'),trunc(sysdate));

Line 4662: insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'),trunc(sysdate));

4658: FROM fnd_sessions
4659: WHERE session_id = userenv('sessionid');
4660: exception
4661: when others then
4662: insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'),trunc(sysdate));
4663: l_session_date := trunc(sysdate);
4664: end;
4665: --
4666: open c_get_person_id(p_user_id => l_user_id);