DBA Data[Home] [Help]

APPS.PAY_MX_TRR_PKG dependencies on FND_SESSIONS

Line 2517: insert into fnd_sessions

2513: dbg('State Tax : '||p_show_state);
2514: dbg('Dimension : '||p_dimension);
2515: dbg('Session Date : '||p_session_date);
2516:
2517: insert into fnd_sessions
2518: (session_id, effective_date)
2519: SELECT userenv('sessionid'),fnd_date.canonical_to_date(p_session_date)
2520: FROM sys.dual
2521: WHERE not exists

Line 2523: FROM fnd_sessions fs

2519: SELECT userenv('sessionid'),fnd_date.canonical_to_date(p_session_date)
2520: FROM sys.dual
2521: WHERE not exists
2522: (SELECT 1
2523: FROM fnd_sessions fs
2524: WHERE fs.session_id = userenv('sessionid')) ;
2525:
2526: l_step := 1;
2527: hr_utility.set_location(g_package || l_procedure_name, 10);