APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on FND_DATE

Line 2489: resource_where_clause ( p_date_from => fnd_date.canonical_to_date(p_date_from)

2485: hr_utility.trace('Request starts execution at '||
2486: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));
2487: END IF;
2488:
2489: resource_where_clause ( p_date_from => fnd_date.canonical_to_date(p_date_from)
2490: , p_date_to => fnd_date.canonical_to_date(p_date_to)
2491: , p_org_id => p_org_id
2492: , p_locn_id => p_locn_id
2493: , p_payroll_id => p_payroll_id

Line 2490: , p_date_to => fnd_date.canonical_to_date(p_date_to)

2486: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));
2487: END IF;
2488:
2489: resource_where_clause ( p_date_from => fnd_date.canonical_to_date(p_date_from)
2490: , p_date_to => fnd_date.canonical_to_date(p_date_to)
2491: , p_org_id => p_org_id
2492: , p_locn_id => p_locn_id
2493: , p_payroll_id => p_payroll_id
2494: , p_supervisor_id => p_supervisor_id

Line 2530: p_tc_from => fnd_date.canonical_to_date(p_date_from),

2526: hr_utility.trace('Processing resource list '||i);
2527: hr_utility.trace(g_res_list_cs(i));
2528: END IF;
2529: load_tc_level_info ( p_resource_list => ltrim(g_res_list_cs(i),' ,'),
2530: p_tc_from => fnd_date.canonical_to_date(p_date_from),
2531: p_tc_to => fnd_date.canonical_to_date(p_date_to),
2532: p_request_id => g_request_id);
2533:
2534:

Line 2531: p_tc_to => fnd_date.canonical_to_date(p_date_to),

2527: hr_utility.trace(g_res_list_cs(i));
2528: END IF;
2529: load_tc_level_info ( p_resource_list => ltrim(g_res_list_cs(i),' ,'),
2530: p_tc_from => fnd_date.canonical_to_date(p_date_from),
2531: p_tc_to => fnd_date.canonical_to_date(p_date_to),
2532: p_request_id => g_request_id);
2533:
2534:
2535: SELECT count(*)