eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DB_PAY_SETUP dependencies on FND_SESSIONS

Line 95: from fnd_sessions ss

91: begin
92: -- Get the session date nb. this is defaulted to todays date
93: select ss.effective_date
94: into v_session_date
95: from fnd_sessions ss
96: where ss.session_id = userenv('sessionid');
97: exception
98: when NO_DATA_FOUND then NULL;
99: end;

Line 548: from fnd_sessions ss

544: begin
545: -- Get the session date nb. this is defaulted to todays date
546: select ss.effective_date
547: into v_session_date
548: from fnd_sessions ss
549: where ss.session_id = userenv('sessionid');
550: exception
551: when NO_DATA_FOUND then NULL;
552: end;

Line 790: from fnd_sessions ss

786: begin
787: -- Get the session date nb. this is defaulted to todays date
788: select ss.effective_date
789: into v_session_date
790: from fnd_sessions ss
791: where ss.session_id = userenv('sessionid');
792: exception
793: when NO_DATA_FOUND then NULL;
794: end;

Line 1067: delete from fnd_sessions where session_id = userenv('sessionid');

1063: PROCEDURE set_session_date(p_session_date date) is
1064: --..
1065: begin
1066: --
1067: delete from fnd_sessions where session_id = userenv('sessionid');
1068: --
1069: insert into fnd_sessions
1070: (SESSION_ID,
1071: EFFECTIVE_DATE)

Line 1069: insert into fnd_sessions

1065: begin
1066: --
1067: delete from fnd_sessions where session_id = userenv('sessionid');
1068: --
1069: insert into fnd_sessions
1070: (SESSION_ID,
1071: EFFECTIVE_DATE)
1072: values
1073: (userenv('sessionid'),

Line 1173: from fnd_sessions ss

1169: begin
1170: -- Get the session date nb. this is defaulted to todays date
1171: select ss.effective_date
1172: into v_session_date
1173: from fnd_sessions ss
1174: where ss.session_id = userenv('sessionid');
1175: exception
1176: when NO_DATA_FOUND then NULL;
1177: end;

Line 1912: from fnd_sessions ss

1908: begin
1909: -- Get the session date nb. this is defaulted to todays date
1910: select ss.effective_date
1911: into v_session_date
1912: from fnd_sessions ss
1913: where ss.session_id = userenv('sessionid');
1914: exception
1915: when NO_DATA_FOUND then NULL;
1916: end;

Line 2070: from fnd_sessions

2066: --
2067: cursor get_eff_date
2068: is
2069: select effective_date
2070: from fnd_sessions
2071: where session_id = userenv('sessionid');
2072: --
2073: cursor get_cat_id(p_bal_type varchar2
2074: ,p_bg_id number

Line 2152: -- default the date from fnd_sessions, as a last resort use sysdate

2148: if g_debug then
2149: hr_utility.set_location('pay_db_pay_setup.create_defined_balance',3.5);
2150: end if;
2151: if p_effective_date is null then
2152: -- default the date from fnd_sessions, as a last resort use sysdate
2153: --
2154: open get_eff_date;
2155: fetch get_eff_date into l_eff_date;
2156: if get_eff_date%notfound then