APPS.PAY_MX_TRR_PKG dependencies on FND_DATE

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

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
2522: (SELECT 1
2523: FROM fnd_sessions fs

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

2526: l_step := 1;
2527: hr_utility.set_location(g_package || l_procedure_name, 10);
2528: dbg('Calling Populate plsql table');
2529:
2530: populate_plsql_table(fnd_date.canonical_to_date(p_start_date_earned) ,
2531: fnd_date.canonical_to_date(p_end_date_earned) ,
2532: p_legal_employer_id ,
2533: p_state_code ,
2534: p_gre_id ,

Line 2531: fnd_date.canonical_to_date(p_end_date_earned) ,

2527: hr_utility.set_location(g_package || l_procedure_name, 10);
2528: dbg('Calling Populate plsql table');
2529:
2530: populate_plsql_table(fnd_date.canonical_to_date(p_start_date_earned) ,
2531: fnd_date.canonical_to_date(p_end_date_earned) ,
2532: p_legal_employer_id ,
2533: p_state_code ,
2534: p_gre_id ,
2535: p_show_isr ,