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 550: from fnd_sessions ss

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

Line 813: from fnd_sessions ss

809: begin
810: -- Get the session date nb. this is defaulted to todays date
811: select ss.effective_date
812: into v_session_date
813: from fnd_sessions ss
814: where ss.session_id = userenv('sessionid');
815: exception
816: when NO_DATA_FOUND then NULL;
817: end;

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

1086: PROCEDURE set_session_date(p_session_date date) is
1087: --..
1088: begin
1089: --
1090: delete from fnd_sessions where session_id = userenv('sessionid');
1091: --
1092: insert into fnd_sessions
1093: (SESSION_ID,
1094: EFFECTIVE_DATE)

Line 1092: insert into fnd_sessions

1088: begin
1089: --
1090: delete from fnd_sessions where session_id = userenv('sessionid');
1091: --
1092: insert into fnd_sessions
1093: (SESSION_ID,
1094: EFFECTIVE_DATE)
1095: values
1096: (userenv('sessionid'),

Line 1196: from fnd_sessions ss

1192: begin
1193: -- Get the session date nb. this is defaulted to todays date
1194: select ss.effective_date
1195: into v_session_date
1196: from fnd_sessions ss
1197: where ss.session_id = userenv('sessionid');
1198: exception
1199: when NO_DATA_FOUND then NULL;
1200: end;

Line 1935: from fnd_sessions ss

1931: begin
1932: -- Get the session date nb. this is defaulted to todays date
1933: select ss.effective_date
1934: into v_session_date
1935: from fnd_sessions ss
1936: where ss.session_id = userenv('sessionid');
1937: exception
1938: when NO_DATA_FOUND then NULL;
1939: end;

Line 2093: from fnd_sessions

2089: --
2090: cursor get_eff_date
2091: is
2092: select effective_date
2093: from fnd_sessions
2094: where session_id = userenv('sessionid');
2095: --
2096: cursor get_cat_id(p_bal_type varchar2
2097: ,p_bg_id number

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

2171: if g_debug then
2172: hr_utility.set_location('pay_db_pay_setup.create_defined_balance',3.5);
2173: end if;
2174: if p_effective_date is null then
2175: -- default the date from fnd_sessions, as a last resort use sysdate
2176: --
2177: open get_eff_date;
2178: fetch get_eff_date into l_eff_date;
2179: if get_eff_date%notfound then