APPS.PAY_US_ACTION_ARCH dependencies on FND_SESSIONS

Line 4991: from fnd_sessions fs

4987: and pts.jurisdiction_code like cp_jurisdiction_code;
4988:
4989: cursor c_fnd_session is
4990: select effective_date
4991: from fnd_sessions fs
4992: where session_id = userenv('sessionid');
4993:
4994: lv_fit_filing_status_code VARCHAR2(30);
4995: lv_fit_filing_status VARCHAR2(80);

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

5062:
5063: open c_fnd_session;
5064: fetch c_fnd_session into ld_session_date;
5065: if c_fnd_session%notfound then
5066: insert into fnd_sessions (session_id, effective_date) values
5067: (userenv('sessionid'), p_run_effective_date);
5068: else
5069: if ld_session_date <> p_run_effective_date then
5070: update fnd_sessions

Line 5070: update fnd_sessions

5066: insert into fnd_sessions (session_id, effective_date) values
5067: (userenv('sessionid'), p_run_effective_date);
5068: else
5069: if ld_session_date <> p_run_effective_date then
5070: update fnd_sessions
5071: set effective_date = p_run_effective_date
5072: where session_id = userenv('sessionid');
5073: end if;
5074: end if;