APPS.PAY_MX_TRR_PKG dependencies on FND_SESSIONS

Line 2397: insert into fnd_sessions

2393: dbg('State Tax : '||p_show_state);
2394: dbg('Dimension : '||p_dimension);
2395: dbg('Session Date : '||p_session_date);
2396:
2397: insert into fnd_sessions
2398: (session_id, effective_date)
2399: SELECT userenv('sessionid'),fnd_date.canonical_to_date(p_session_date)
2400: FROM sys.dual
2401: WHERE not exists

Line 2403: FROM fnd_sessions fs

2399: SELECT userenv('sessionid'),fnd_date.canonical_to_date(p_session_date)
2400: FROM sys.dual
2401: WHERE not exists
2402: (SELECT 1
2403: FROM fnd_sessions fs
2404: WHERE fs.session_id = userenv('sessionid')) ;
2405:
2406: l_step := 1;
2407: hr_utility.set_location(g_package || l_procedure_name, 10);