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 460: INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3) */

456: -- Forced hints in the below queries to pick up the right path.
457:
458: cursor c_timecard_detail (p_tbb_id number, p_tbb_ovn number,p_resource_id number) is
459: select /*+ LEADING(day)
460: INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3) */
461: detail.time_building_block_id, detail.object_version_number
462: from hxc_time_building_blocks detail,hxc_time_building_blocks day
463: where day.parent_building_block_id = p_tbb_id
464: and day.parent_building_block_ovn = p_tbb_ovn

Line 462: from hxc_time_building_blocks detail,hxc_time_building_blocks day

458: cursor c_timecard_detail (p_tbb_id number, p_tbb_ovn number,p_resource_id number) is
459: select /*+ LEADING(day)
460: INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3) */
461: detail.time_building_block_id, detail.object_version_number
462: from hxc_time_building_blocks detail,hxc_time_building_blocks day
463: where day.parent_building_block_id = p_tbb_id
464: and day.parent_building_block_ovn = p_tbb_ovn
465: and day.scope = 'DAY'
466: and day.resource_id = p_resource_id

Line 470: from hxc_time_building_blocks day2

466: and day.resource_id = p_resource_id
467: and day.time_building_block_id = detail.parent_building_block_id
468: and detail.parent_building_block_ovn =
469: (select max(day2.object_version_number)
470: from hxc_time_building_blocks day2
471: where day2.time_building_block_id = day.time_building_block_id)
472: and detail.scope = 'DETAIL'
473: and detail.resource_id = p_resource_id
474: and detail.object_version_number =

Line 476: from hxc_time_building_blocks detail2

472: and detail.scope = 'DETAIL'
473: and detail.resource_id = p_resource_id
474: and detail.object_version_number =
475: (select max(detail2.object_version_number)
476: from hxc_time_building_blocks detail2
477: where detail2.time_building_block_id = detail.time_building_block_id)
478: UNION
479: select /*+ INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3)*/
480: day.time_building_block_id, day.object_version_number

Line 479: select /*+ INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3)*/

475: (select max(detail2.object_version_number)
476: from hxc_time_building_blocks detail2
477: where detail2.time_building_block_id = detail.time_building_block_id)
478: UNION
479: select /*+ INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3)*/
480: day.time_building_block_id, day.object_version_number
481: from hxc_time_building_blocks day
482: where day.parent_building_block_id = p_tbb_id
483: and day.parent_building_block_ovn = p_tbb_ovn

Line 481: from hxc_time_building_blocks day

477: where detail2.time_building_block_id = detail.time_building_block_id)
478: UNION
479: select /*+ INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3)*/
480: day.time_building_block_id, day.object_version_number
481: from hxc_time_building_blocks day
482: where day.parent_building_block_id = p_tbb_id
483: and day.parent_building_block_ovn = p_tbb_ovn
484: and day.scope = 'DAY'
485: and day.resource_id = p_resource_id;

Line 490: INDEX(detail HXC_TIME_BUILDING_BLOCKS_PK)*/

486:
487:
488: cursor c_detail_timecard (p_tbb_id number, p_tbb_ovn number,p_resource_id number) is
489: select /*+ LEADING(detail)
490: INDEX(detail HXC_TIME_BUILDING_BLOCKS_PK)*/
491: day.parent_building_block_id, day.parent_building_block_ovn
492: from hxc_time_building_blocks detail, hxc_time_building_blocks day
493: where detail.time_building_block_id = p_tbb_id
494: and detail.object_version_number = p_tbb_ovn

Line 492: from hxc_time_building_blocks detail, hxc_time_building_blocks day

488: cursor c_detail_timecard (p_tbb_id number, p_tbb_ovn number,p_resource_id number) is
489: select /*+ LEADING(detail)
490: INDEX(detail HXC_TIME_BUILDING_BLOCKS_PK)*/
491: day.parent_building_block_id, day.parent_building_block_ovn
492: from hxc_time_building_blocks detail, hxc_time_building_blocks day
493: where detail.time_building_block_id = p_tbb_id
494: and detail.object_version_number = p_tbb_ovn
495: and detail.scope = 'DETAIL'
496: and detail.resource_id = p_resource_id

Line 504: select /*+ INDEX(detail HXC_TIME_BUILDING_BLOCKS_PK) */

500: and day.resource_id = p_resource_id
501: and day.time_building_block_id = detail.parent_building_block_id
502: and day.object_version_number = detail.parent_building_block_ovn
503: UNION
504: select /*+ INDEX(detail HXC_TIME_BUILDING_BLOCKS_PK) */
505: detail.parent_building_block_id, detail.parent_building_block_ovn
506: from hxc_time_building_blocks detail
507: where detail.time_building_block_id = p_tbb_id
508: and detail.object_version_number = p_tbb_ovn

Line 506: from hxc_time_building_blocks detail

502: and day.object_version_number = detail.parent_building_block_ovn
503: UNION
504: select /*+ INDEX(detail HXC_TIME_BUILDING_BLOCKS_PK) */
505: detail.parent_building_block_id, detail.parent_building_block_ovn
506: from hxc_time_building_blocks detail
507: where detail.time_building_block_id = p_tbb_id
508: and detail.object_version_number = p_tbb_ovn
509: and detail.scope = 'DETAIL'
510: and detail.resource_id = p_resource_id;

Line 1037: from hxc_time_building_blocks

1033:
1034: cursor c_timecard_info(p_tbb_id number, p_tbb_ovn number) is
1035: select scope, resource_id, stop_time, start_time, parent_building_Block_id,
1036: parent_building_block_ovn
1037: from hxc_time_building_blocks
1038: where time_building_block_id = p_tbb_id
1039: and object_version_number = p_tbb_ovn;
1040: --and date_to = hr_general.end_of_time;
1041: