APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on FND_DATE

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

2413: hr_utility.trace('Request starts execution at '||
2414: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));
2415: END IF;
2416:
2417: resource_where_clause ( p_date_from => fnd_date.canonical_to_date(p_date_from)
2418: , p_date_to => fnd_date.canonical_to_date(p_date_to)
2419: , p_org_id => p_org_id
2420: , p_locn_id => p_locn_id
2421: , p_payroll_id => p_payroll_id

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

2414: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));
2415: END IF;
2416:
2417: resource_where_clause ( p_date_from => fnd_date.canonical_to_date(p_date_from)
2418: , p_date_to => fnd_date.canonical_to_date(p_date_to)
2419: , p_org_id => p_org_id
2420: , p_locn_id => p_locn_id
2421: , p_payroll_id => p_payroll_id
2422: , p_supervisor_id => p_supervisor_id

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

2451: hr_utility.trace('Processing resource list '||i);
2452: hr_utility.trace(g_res_list_cs(i));
2453: END IF;
2454: load_tc_level_info ( p_resource_list => ltrim(g_res_list_cs(i),' ,'),
2455: p_tc_from => fnd_date.canonical_to_date(p_date_from),
2456: p_tc_to => fnd_date.canonical_to_date(p_date_to),
2457: p_request_id => g_request_id);
2458:
2459:

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

2452: hr_utility.trace(g_res_list_cs(i));
2453: END IF;
2454: load_tc_level_info ( p_resource_list => ltrim(g_res_list_cs(i),' ,'),
2455: p_tc_from => fnd_date.canonical_to_date(p_date_from),
2456: p_tc_to => fnd_date.canonical_to_date(p_date_to),
2457: p_request_id => g_request_id);
2458:
2459:
2460: SELECT count(*)