APPS.HXC_TCSUMMARY_MIGRATE dependencies on HXC_BLOCK_TABLE_TYPE

Line 29: l_blocks hxc_block_table_type;

25: tbb.scope = 'TIMECARD' and
26: tbb.date_to <> hr_general.end_of_time);
27:
28:
29: l_blocks hxc_block_table_type;
30:
31: Begin
32:
33: for timecard_rec in c_timecards loop

Line 71: -- l_blocks hxc_block_table_type;

67: tbb.object_version_number = ts.template_ovn and
68: tbb.scope = 'TIMECARD_TEMPLATE' and
69: tbb.date_to <> hr_general.end_of_time);
70:
71: -- l_blocks hxc_block_table_type;
72:
73: Begin
74:
75: for template_rec in c_templates loop

Line 104: l_blocks hxc_block_table_type;

100: from hxc_timecard_summary
101: where timecard_id = tbb.time_building_block_id and
102: timecard_ovn = tbb.object_version_number);
103:
104: l_blocks hxc_block_table_type;
105:
106:
107: Begin
108:

Line 140: l_blocks hxc_block_table_type;

136: from hxc_template_summary
137: where template_id = tbb.time_building_block_id and
138: template_ovn = tbb.object_version_number);
139:
140: l_blocks hxc_block_table_type;
141:
142: Begin
143:
144: for template_rec in c_templates(p_resource_id) loop