APPS.HXC_EXT_TIMECARD dependencies on HXC_TIME_BUILDING_BLOCKS

Line 22: hxc_time_building_blocks tbb_time

18: , tbb_time.time_building_block_id
19: , tbb_time.object_version_number
20: , tbb_summary.approval_status
21: FROM
22: hxc_time_building_blocks tbb_time
23: , hxc_timecard_summary tbb_summary
24: WHERE
25: tbb_time.resource_id = p_person_id AND
26: tbb_time.scope = 'TIMECARD' AND

Line 28: from hxc_time_building_Blocks tbb

24: WHERE
25: tbb_time.resource_id = p_person_id AND
26: tbb_time.scope = 'TIMECARD' AND
27: tbb_time.object_version_number = ( select MAX( tbb.object_version_number )
28: from hxc_time_building_Blocks tbb
29: where tbb.time_building_block_id = tbb_time.time_building_block_id )
30: AND
31: p_start_date <= tbb_time.stop_time AND
32: p_end_date >= tbb_time.start_time

Line 50: hxc_time_building_blocks tbb_time

46: , tbb_time.time_building_block_id
47: , tbb_time.object_version_number
48: , tbb_summary.approval_status
49: FROM
50: hxc_time_building_blocks tbb_time
51: , hxc_timecard_summary tbb_summary
52: WHERE
53: tbb_time.resource_id = p_person_id AND
54: tbb_time.scope = 'TIMECARD' AND

Line 56: from hxc_time_building_Blocks tbb

52: WHERE
53: tbb_time.resource_id = p_person_id AND
54: tbb_time.scope = 'TIMECARD' AND
55: tbb_time.object_version_number = ( select MAX( tbb.object_version_number )
56: from hxc_time_building_Blocks tbb
57: where tbb.time_building_block_id = tbb_time.time_building_block_id )
58: AND
59: tbb_summary.timecard_id = tbb_time.time_building_block_id AND
60: tbb_summary.timecard_ovn = tbb_time.object_version_number

Line 83: hxc_time_building_blocks tbb_day

79: , ta.attribute5
80: , ta.attribute6
81: , ta.attribute7
82: FROM
83: hxc_time_building_blocks tbb_day
84: , hxc_time_building_blocks tbb_detail
85: , hxc_time_attribute_usages tau
86: , hxc_time_attributes ta
87: WHERE

Line 84: , hxc_time_building_blocks tbb_detail

80: , ta.attribute6
81: , ta.attribute7
82: FROM
83: hxc_time_building_blocks tbb_day
84: , hxc_time_building_blocks tbb_detail
85: , hxc_time_attribute_usages tau
86: , hxc_time_attributes ta
87: WHERE
88: tbb_day.parent_building_block_id = p_tbb_id AND

Line 91: from hxc_time_building_blocks tbb

87: WHERE
88: tbb_day.parent_building_block_id = p_tbb_id AND
89: tbb_day.parent_building_block_ovn = p_tbb_ovn AND
90: tbb_day.object_version_number = ( select MAX ( tbb.object_version_number )
91: from hxc_time_building_blocks tbb
92: where tbb.time_building_block_id = tbb_day.time_building_block_id )
93: AND
94: tbb_detail.parent_building_block_id = tbb_day.time_building_block_id AND
95: tbb_detail.object_version_number = ( select MAX ( tbb1.object_version_number )

Line 96: from hxc_time_building_blocks tbb1

92: where tbb.time_building_block_id = tbb_day.time_building_block_id )
93: AND
94: tbb_detail.parent_building_block_id = tbb_day.time_building_block_id AND
95: tbb_detail.object_version_number = ( select MAX ( tbb1.object_version_number )
96: from hxc_time_building_blocks tbb1
97: where tbb1.time_building_block_id
98: = tbb_detail.time_building_block_id )
99: AND
100: tau.time_building_block_id = tbb_detail.time_building_block_id AND

Line 697: l_old_det_id hxc_time_building_blocks.time_building_block_id%TYPE := -1;

693: l_summary_written BOOLEAN := FALSE;
694: l_skip_PO BOOLEAN := FALSE;
695: l_already_called_PO BOOLEAN := FALSE;
696:
697: l_old_det_id hxc_time_building_blocks.time_building_block_id%TYPE := -1;
698:
699: l_include VARCHAR2(1) := 'N';
700:
701: l_proc VARCHAR2(72) ;