APPS.PAY_US_ACTION_ARCH dependencies on FND_SESSIONS

Line 5997: from fnd_sessions fs

5993: and pts.effective_end_date; -- 8804636 RLN
5994:
5995: cursor c_fnd_session is
5996: select effective_date
5997: from fnd_sessions fs
5998: where session_id = userenv('sessionid');
5999:
6000: /*Added for Bug#9872952*/
6001: CURSOR c_get_wage_acc_flag IS

Line 6110: insert into fnd_sessions (session_id, effective_date) values

6106:
6107: open c_fnd_session;
6108: fetch c_fnd_session into ld_session_date;
6109: if c_fnd_session%notfound then
6110: insert into fnd_sessions (session_id, effective_date) values
6111: (userenv('sessionid'), p_run_effective_date);
6112: else
6113: if ld_session_date <> p_run_effective_date then
6114: update fnd_sessions

Line 6114: update fnd_sessions

6110: insert into fnd_sessions (session_id, effective_date) values
6111: (userenv('sessionid'), p_run_effective_date);
6112: else
6113: if ld_session_date <> p_run_effective_date then
6114: update fnd_sessions
6115: set effective_date = p_run_effective_date
6116: where session_id = userenv('sessionid');
6117: end if;
6118: end if;