APPS.HXC_LOCK_API dependencies on HXC_TIME_BUILDING_BLOCKS

Line 122: from hxc_time_building_blocks

118:
119: cursor c_timecard_info (p_tbb_id number, p_tbb_ovn number) is
120: select scope, resource_id, stop_time, start_time, parent_building_Block_id,
121: parent_building_block_ovn
122: from hxc_time_building_blocks
123: where time_building_block_id = p_tbb_id
124: and object_version_number = p_tbb_ovn;
125: --and date_to = hr_general.end_of_time;
126:

Line 457: from hxc_time_building_blocks detail,hxc_time_building_blocks day

453: )IS
454:
455: cursor c_timecard_detail (p_tbb_id number, p_tbb_ovn number,p_resource_id number) is
456: select detail.time_building_block_id, detail.object_version_number
457: from hxc_time_building_blocks detail,hxc_time_building_blocks day
458: where day.parent_building_block_id = p_tbb_id
459: and day.parent_building_block_ovn = p_tbb_ovn
460: and day.scope = 'DAY'
461: and day.resource_id = p_resource_id

Line 465: from hxc_time_building_blocks day2

461: and day.resource_id = p_resource_id
462: and day.time_building_block_id = detail.parent_building_block_id
463: and detail.parent_building_block_ovn =
464: (select max(day2.object_version_number)
465: from hxc_time_building_blocks day2
466: where day2.time_building_block_id = day.time_building_block_id)
467: and detail.scope = 'DETAIL'
468: and detail.resource_id = p_resource_id
469: and detail.object_version_number =

Line 471: from hxc_time_building_blocks detail2

467: and detail.scope = 'DETAIL'
468: and detail.resource_id = p_resource_id
469: and detail.object_version_number =
470: (select max(detail2.object_version_number)
471: from hxc_time_building_blocks detail2
472: where detail2.time_building_block_id = detail.time_building_block_id)
473: UNION
474: select day.time_building_block_id, day.object_version_number
475: from hxc_time_building_blocks day

Line 475: from hxc_time_building_blocks day

471: from hxc_time_building_blocks detail2
472: where detail2.time_building_block_id = detail.time_building_block_id)
473: UNION
474: select day.time_building_block_id, day.object_version_number
475: from hxc_time_building_blocks day
476: where day.parent_building_block_id = p_tbb_id
477: and day.parent_building_block_ovn = p_tbb_ovn
478: and day.scope = 'DAY'
479: and day.resource_id = p_resource_id;

Line 484: from hxc_time_building_blocks detail, hxc_time_building_blocks day

480:
481:
482: cursor c_detail_timecard (p_tbb_id number, p_tbb_ovn number,p_resource_id number) is
483: select day.parent_building_block_id, day.parent_building_block_ovn
484: from hxc_time_building_blocks detail, hxc_time_building_blocks day
485: where detail.time_building_block_id = p_tbb_id
486: and detail.object_version_number = p_tbb_ovn
487: and detail.scope = 'DETAIL'
488: and detail.resource_id = p_resource_id

Line 497: from hxc_time_building_blocks detail

493: and day.time_building_block_id = detail.parent_building_block_id
494: and day.object_version_number = detail.parent_building_block_ovn
495: UNION
496: select detail.parent_building_block_id, detail.parent_building_block_ovn
497: from hxc_time_building_blocks detail
498: where detail.time_building_block_id = p_tbb_id
499: and detail.object_version_number = p_tbb_ovn
500: and detail.scope = 'DETAIL'
501: and detail.resource_id = p_resource_id;

Line 1018: from hxc_time_building_blocks

1014:
1015: cursor c_timecard_info(p_tbb_id number, p_tbb_ovn number) is
1016: select scope, resource_id, stop_time, start_time, parent_building_Block_id,
1017: parent_building_block_ovn
1018: from hxc_time_building_blocks
1019: where time_building_block_id = p_tbb_id
1020: and object_version_number = p_tbb_ovn;
1021: --and date_to = hr_general.end_of_time;
1022: