APPS.PAY_MX_TRR_PKG dependencies on FND_DATE

Line 2399: SELECT userenv('sessionid'),fnd_date.canonical_to_date(p_session_date)

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
2402: (SELECT 1
2403: FROM fnd_sessions fs

Line 2410: populate_plsql_table(fnd_date.canonical_to_date(p_start_date_earned) ,

2406: l_step := 1;
2407: hr_utility.set_location(g_package || l_procedure_name, 10);
2408: dbg('Calling Populate plsql table');
2409:
2410: populate_plsql_table(fnd_date.canonical_to_date(p_start_date_earned) ,
2411: fnd_date.canonical_to_date(p_end_date_earned) ,
2412: p_legal_employer_id ,
2413: p_state_code ,
2414: p_gre_id ,

Line 2411: fnd_date.canonical_to_date(p_end_date_earned) ,

2407: hr_utility.set_location(g_package || l_procedure_name, 10);
2408: dbg('Calling Populate plsql table');
2409:
2410: populate_plsql_table(fnd_date.canonical_to_date(p_start_date_earned) ,
2411: fnd_date.canonical_to_date(p_end_date_earned) ,
2412: p_legal_employer_id ,
2413: p_state_code ,
2414: p_gre_id ,
2415: p_show_isr ,