DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ARCHIVE dependencies on FND_SESSIONS

Line 195: FROM fnd_sessions

191:
192:
193: SELECT TRUNC(effective_date)
194: INTO g_system_date
195: FROM fnd_sessions
196: WHERE session_id = USERENV('sessionid');
197:
198: pay_in_utils.set_location(g_debug,l_procedure, 20);
199:

Line 477: FROM fnd_sessions

473:
474: pay_in_utils.set_location(g_debug,l_procedure, 20);
475: SELECT TRUNC(effective_date)
476: INTO g_system_date
477: FROM fnd_sessions
478: WHERE session_id = USERENV('sessionid');
479:
480: SELECT FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
481: INTO g_bg_id