APPS.OTA_TRB_API_PROCEDURES dependencies on HR_API

Line 575: and nvl(end_date,nvl(p_req_to,hr_api.g_eot)) >= nvl(p_req_to,hr_api.g_eot);

571: select 1
572: from ota_suppliable_resources
573: where supplied_resource_id = p_supplied_resource_id
574: and start_date <= p_req_from
575: and nvl(end_date,nvl(p_req_to,hr_api.g_eot)) >= nvl(p_req_to,hr_api.g_eot);
576: */
577:
578: --
579: begin

Line 653: IF p_req_from <= nvl(p_req_to,hr_api.g_eot) THEN null;

649: --
650: begin
651: hr_utility.set_location('Entering:'||l_proc,5);
652: --
653: IF p_req_from <= nvl(p_req_to,hr_api.g_eot) THEN null;
654: ELSE fnd_message.set_name('OTA','OTA_13271_TRB_FROM_TO_DATES');
655: fnd_message.raise_error;
656: END IF;
657: --

Line 1892: nvl(rud.start_date, hr_api.g_sot) and nvl(rud.end_date, hr_api.g_eot)

1888: ota_resource_usages rud
1889: Where rud.offering_id = (select evt.parent_offering_id from ota_events evt -- bug 3494404
1890: where evt.event_id = p_event_id) -- bug 3494404
1891: and p_event_start_date between
1892: nvl(rud.start_date, hr_api.g_sot) and nvl(rud.end_date, hr_api.g_eot)
1893: and rud.supplied_resource_id is not null
1894: and rud.required_flag = 'Y'
1895: and not exists
1896: (Select null