DBA Data[Home] [Help]

APPS.HXC_TBB_BUS dependencies on HR_GENERAL

Line 295: and date_to = hr_general.end_of_time;

291: select null
292: from hxc_time_building_blocks
293: where time_building_block_id = p_parent_building_block_id
294: and object_version_number = p_parent_building_block_ovn
295: and date_to = hr_general.end_of_time;
296:
297: l_valid varchar2(1);
298:
299: begin

Line 317: if((p_date_to = hr_general.end_of_time) and (p_scope in ('DAY','DETAIL'))) then

313: fnd_message.set_name('PAY', 'HXC_NO_PARENT_BUILDING_BLOCK');
314: fnd_message.raise_error;
315: else
316: close c_timecard_parent;
317: if((p_date_to = hr_general.end_of_time) and (p_scope in ('DAY','DETAIL'))) then
318: open c_valid_parent;
319: if(c_valid_parent%notfound) then
320: close c_valid_parent;
321: fnd_message.set_name('HXC','HXC_366502_INVALID_PARENT_DEP');

Line 406: and date_to = hr_general.end_of_time;

402: and scope = 'TIMECARD'
403: and resource_type = p_resource_type
404: and p_start_time <= stop_time
405: and p_stop_time >= start_time
406: and date_to = hr_general.end_of_time;
407:
408: l_two_timecards VARCHAR2(2);
409: l_proc varchar2(72);
410:

Line 666: and p_rec.date_to = hr_general.end_of_time))

662:
663: if(NOT(p_rec.type = 'RANGE'
664: and p_rec.start_time is null
665: and p_rec.stop_time is null
666: and p_rec.date_to = hr_general.end_of_time))
667: then
668:
669: chk_start_time
670: (p_start_time => p_rec.start_time