eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_APPROVAL_WF_HELPER dependencies on HXC_TIME_BUILDING_BLOCKS

Line 8: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

4: g_debug boolean :=hr_utility.debug_enabled;
5:
6: -- This will determine the error admin role
7: FUNCTION find_admin_role(
8: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
9: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
10: return hxc_approval_styles.admin_role%type
11: is
12:

Line 9: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

5:
6: -- This will determine the error admin role
7: FUNCTION find_admin_role(
8: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
9: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
10: return hxc_approval_styles.admin_role%type
11: is
12:
13: l_admin_role hxc_approval_styles.admin_role%type;

Line 16: CURSOR c_admin_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

12:
13: l_admin_role hxc_approval_styles.admin_role%type;
14: l_proc constant varchar2(61) := g_pkg ||'find_admin_role';
15:
16: CURSOR c_admin_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
17: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
18: is
19: SELECT
20: has.admin_role

Line 17: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

13: l_admin_role hxc_approval_styles.admin_role%type;
14: l_proc constant varchar2(61) := g_pkg ||'find_admin_role';
15:
16: CURSOR c_admin_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
17: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
18: is
19: SELECT
20: has.admin_role
21: FROM

Line 22: hxc_time_building_blocks htbb,

18: is
19: SELECT
20: has.admin_role
21: FROM
22: hxc_time_building_blocks htbb,
23: hxc_approval_styles has
24: WHERE
25: htbb.time_building_block_id = p_timecard_id and
26: htbb.object_version_number = p_timecard_ovn and

Line 72: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

68:
69: -- This will determine the error admin role
70:
71: FUNCTION find_error_admin_role(
72: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
73: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
74: return hxc_approval_styles.error_admin_role%type
75: is
76:

Line 73: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

69: -- This will determine the error admin role
70:
71: FUNCTION find_error_admin_role(
72: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
73: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
74: return hxc_approval_styles.error_admin_role%type
75: is
76:
77: l_error_admin_role hxc_approval_styles.error_admin_role%type;

Line 80: CURSOR c_error_admin_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

76:
77: l_error_admin_role hxc_approval_styles.error_admin_role%type;
78: l_proc constant varchar2(61) := g_pkg ||'find_error_admin_role';
79:
80: CURSOR c_error_admin_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
81: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
82: is
83: SELECT
84: has.error_admin_role

Line 81: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

77: l_error_admin_role hxc_approval_styles.error_admin_role%type;
78: l_proc constant varchar2(61) := g_pkg ||'find_error_admin_role';
79:
80: CURSOR c_error_admin_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
81: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
82: is
83: SELECT
84: has.error_admin_role
85: FROM

Line 86: hxc_time_building_blocks htbb,

82: is
83: SELECT
84: has.error_admin_role
85: FROM
86: hxc_time_building_blocks htbb,
87: hxc_approval_styles has
88: WHERE
89: htbb.time_building_block_id = p_timecard_id and
90: htbb.object_version_number = p_timecard_ovn and

Line 129: FUNCTION find_preparer_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

125: return l_error_admin_role;
126:
127: END find_error_admin_role;
128: ----------------------------------------------------------------------------------------------
129: FUNCTION find_preparer_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
130: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
131: return wf_local_roles.name%type
132: is
133:

Line 130: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

126:
127: END find_error_admin_role;
128: ----------------------------------------------------------------------------------------------
129: FUNCTION find_preparer_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
130: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
131: return wf_local_roles.name%type
132: is
133:
134: l_user_id number;

Line 149: CURSOR c_latest_detail_block(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

145:
146: --Bug 5370557
147: --Since for a blank timecard there are no detail blocks hence we need to fetch the preparer role from
148: --the most recent block, it can be TIMECARD,DAY or DETAIL.
149: CURSOR c_latest_detail_block(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
150: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
151: is
152: select distinct last_updated_by
153: from hxc_time_building_blocks

Line 150: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

146: --Bug 5370557
147: --Since for a blank timecard there are no detail blocks hence we need to fetch the preparer role from
148: --the most recent block, it can be TIMECARD,DAY or DETAIL.
149: CURSOR c_latest_detail_block(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
150: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
151: is
152: select distinct last_updated_by
153: from hxc_time_building_blocks
154: where last_update_date = (select max(last_update_date)

Line 153: from hxc_time_building_blocks

149: CURSOR c_latest_detail_block(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
150: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
151: is
152: select distinct last_updated_by
153: from hxc_time_building_blocks
154: where last_update_date = (select max(last_update_date)
155: from HXC_TIME_BUILDING_BLOCKS
156: where date_to=hr_general.END_of_time
157: connect by prior time_building_block_id=parent_building_block_id

Line 155: from HXC_TIME_BUILDING_BLOCKS

151: is
152: select distinct last_updated_by
153: from hxc_time_building_blocks
154: where last_update_date = (select max(last_update_date)
155: from HXC_TIME_BUILDING_BLOCKS
156: where date_to=hr_general.END_of_time
157: connect by prior time_building_block_id=parent_building_block_id
158: start with time_building_block_id=p_timecard_id)
159: and date_to=hr_general.END_of_time

Line 268: FUNCTION find_supervisor_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

264:
265: END find_full_name_from_role;
266:
267: --------------------------------------------------------------------------------------------------------
268: FUNCTION find_supervisor_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
269: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
270: return wf_local_roles.name%type
271: is
272:

Line 269: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

265: END find_full_name_from_role;
266:
267: --------------------------------------------------------------------------------------------------------
268: FUNCTION find_supervisor_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
269: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
270: return wf_local_roles.name%type
271: is
272:
273: l_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 278: CURSOR c_get_supervisor(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

274: l_name wf_local_roles.name%type;
275: l_display_name wf_local_roles.display_name%type;
276: l_proc constant varchar2(61) := g_pkg ||'find_supervisor_role';
277:
278: CURSOR c_get_supervisor(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
279: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
280: is
281: select supervisor_id
282: from per_all_assignments_f

Line 279: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

275: l_display_name wf_local_roles.display_name%type;
276: l_proc constant varchar2(61) := g_pkg ||'find_supervisor_role';
277:
278: CURSOR c_get_supervisor(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
279: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
280: is
281: select supervisor_id
282: from per_all_assignments_f
283: where person_id = (select resource_id

Line 284: from hxc_time_building_blocks

280: is
281: select supervisor_id
282: from per_all_assignments_f
283: where person_id = (select resource_id
284: from hxc_time_building_blocks
285: where time_building_block_id=p_timecard_id
286: and object_version_number =p_timecard_ovn)
287: and assignment_type in ('E','C')
288: and primary_flag = 'Y'

Line 295: --This FUNCTION uses the HXC_TIME_BUILDING_BLOCKS table and PER_ALL_ASSIGNMENTS_F to find the supervisor

291: BEGIN
292: if g_debug then
293: hr_utility.set_location(l_proc, 10);
294: end if;
295: --This FUNCTION uses the HXC_TIME_BUILDING_BLOCKS table and PER_ALL_ASSIGNMENTS_F to find the supervisor
296: --corresponding to the primary employee or contingent worker assignment, and then subsequently use that
297: --supervisor id to find the appropriate role from the workflow directory service using the PER original system.
298:
299: open c_get_supervisor(p_timecard_id,p_timecard_ovn);

Line 312: FUNCTION find_worker_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

308: return l_name;
309:
310: END find_supervisor_role;
311: -----------------------------------------------------------------------------------------------------
312: FUNCTION find_worker_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
313: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
314: return wf_local_roles.name%type
315: is
316:

Line 313: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

309:
310: END find_supervisor_role;
311: -----------------------------------------------------------------------------------------------------
312: FUNCTION find_worker_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
313: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
314: return wf_local_roles.name%type
315: is
316:
317: l_worker_id hxc_time_building_blocks.resource_id%TYPE;

Line 317: l_worker_id hxc_time_building_blocks.resource_id%TYPE;

313: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
314: return wf_local_roles.name%type
315: is
316:
317: l_worker_id hxc_time_building_blocks.resource_id%TYPE;
318: l_name wf_local_roles.name%type;
319: l_display_name wf_local_roles.display_name%type;
320: l_proc constant varchar2(61) := g_pkg ||'find_worker_role';
321:

Line 323: CURSOR c_get_worker_id(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

319: l_display_name wf_local_roles.display_name%type;
320: l_proc constant varchar2(61) := g_pkg ||'find_worker_role';
321:
322:
323: CURSOR c_get_worker_id(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
324: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
325: is
326: select resource_id
327: from hxc_time_building_blocks

Line 324: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

320: l_proc constant varchar2(61) := g_pkg ||'find_worker_role';
321:
322:
323: CURSOR c_get_worker_id(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
324: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
325: is
326: select resource_id
327: from hxc_time_building_blocks
328: where time_building_block_id=p_timecard_id

Line 327: from hxc_time_building_blocks

323: CURSOR c_get_worker_id(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
324: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
325: is
326: select resource_id
327: from hxc_time_building_blocks
328: where time_building_block_id=p_timecard_id
329: and object_version_number =p_timecard_ovn;
330:
331:

Line 337: --HXC_TIME_BUILDING_BLOCKS to locate the resource id associated with the timecard, and from there uses the

333: if g_debug then
334: hr_utility.set_location(l_proc, 10);
335: end if;
336: --This is a private FUNCTION, which is passed the timecard id and object version number. This uses
337: --HXC_TIME_BUILDING_BLOCKS to locate the resource id associated with the timecard, and from there uses the
338: --workflow directory service getrolename call to obtain the role associated with the user, using the PER original system.
339:
340: open c_get_worker_id(p_timecard_id,p_timecard_ovn);
341: fetch c_get_worker_id into l_worker_id;

Line 478: CURSOR c_get_app_comp_id(p_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE)

474: p_tc_bbovn number;
475: l_proc constant varchar2(61) := g_pkg ||'get_notif_attribute_values';
476:
477:
478: CURSOR c_get_app_comp_id(p_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE)
479: is
480: select approval_comp_id
481: from hxc_app_period_summary
482: where application_period_id = p_app_bb_id;

Line 484: CURSOR c_get_any_comp_id(p_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE)

480: select approval_comp_id
481: from hxc_app_period_summary
482: where application_period_id = p_app_bb_id;
483:
484: CURSOR c_get_any_comp_id(p_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE)
485: is
486: select happs.approval_comp_id
487: from hxc_tc_ap_links htal, hxc_app_period_summary happs
488: where htal.timecard_id = p_app_bb_id

Line 497: hxc_time_building_blocks htb

493: is
494: select hac.approval_comp_id
495: from hxc_approval_comps hac,
496: hxc_approval_styles has,
497: hxc_time_building_blocks htb
498: where htb.time_building_block_id =p_bb_id
499: and htb.object_version_number = p_bb_ovn
500: and htb.approval_style_id = has.approval_style_id
501: and has.approval_style_id = hac.APPROVAL_STYLE_ID

Line 710: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,

706: FUNCTION send_notification
707: (p_approval_comp_id in number,
708: p_action_code in wf_item_attribute_values.text_value%type,
709: p_recipient_code in wf_item_attribute_values.text_value%type,
710: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
711: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
712: p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
713: p_app_period_ovn in hxc_time_building_blocks.object_version_number%type)
714:

Line 711: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,

707: (p_approval_comp_id in number,
708: p_action_code in wf_item_attribute_values.text_value%type,
709: p_recipient_code in wf_item_attribute_values.text_value%type,
710: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
711: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
712: p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
713: p_app_period_ovn in hxc_time_building_blocks.object_version_number%type)
714:
715: Return boolean is

Line 712: p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,

708: p_action_code in wf_item_attribute_values.text_value%type,
709: p_recipient_code in wf_item_attribute_values.text_value%type,
710: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
711: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
712: p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
713: p_app_period_ovn in hxc_time_building_blocks.object_version_number%type)
714:
715: Return boolean is
716:

Line 713: p_app_period_ovn in hxc_time_building_blocks.object_version_number%type)

709: p_recipient_code in wf_item_attribute_values.text_value%type,
710: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
711: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
712: p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
713: p_app_period_ovn in hxc_time_building_blocks.object_version_number%type)
714:
715: Return boolean is
716:
717:

Line 720: l_app_bb_id hxc_time_building_blocks.time_building_block_id%type;

716:
717:
718: l_result boolean;
719: l_dummy varchar2(1) := 'N';
720: l_app_bb_id hxc_time_building_blocks.time_building_block_id%type;
721: l_timecard_fyi varchar2(1000);
722: l_item_key wf_items.item_key%type;
723: l_tc_url varchar2(1000);
724: l_block_index PLS_INTEGER := 1;

Line 726: l_resource_id hxc_time_building_blocks.resource_id%type;

722: l_item_key wf_items.item_key%type;
723: l_tc_url varchar2(1000);
724: l_block_index PLS_INTEGER := 1;
725: l_tk_audit_item_key hxc_timecard_summary.tk_audit_item_key%type;
726: l_resource_id hxc_time_building_blocks.resource_id%type;
727: l_recipient_action_code wf_item_attribute_values.text_value%type;
728: l_action_code wf_item_attribute_values.text_value%type;
729: l_notification_id wf_notifications.notification_id%type;
730: l_recipient_role wf_local_roles.name%type;

Line 755: CURSOR c_get_detail_blocks(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type)

751: and hacnu.enabled_flag = 'Y';
752:
753:
754:
755: CURSOR c_get_detail_blocks(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type)
756: is
757: select adl.time_building_block_id,
758: adl.time_building_block_ovn
759: from hxc_ap_detail_links adl

Line 763: CURSOR c_get_notifications(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

759: from hxc_ap_detail_links adl
760: where adl.application_period_id = p_application_period_id;
761:
762:
763: CURSOR c_get_notifications(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
764: ,p_recipient_role in wf_local_roles.name%type)
765: is
766: select wias.item_key,
767: wn.notification_id,

Line 831: type rec_type is record(p_id hxc_time_building_blocks.time_building_block_id%TYPE,

827: from hxc_timecard_summary
828: where timecard_id = p_timecard_id;
829:
830:
831: type rec_type is record(p_id hxc_time_building_blocks.time_building_block_id%TYPE,
832: p_ovn hxc_time_building_blocks.time_building_block_id%TYPE);
833:
834:
835: TYPE tab_type IS TABLE OF rec_type INDEX BY BINARY_INTEGER;

Line 832: p_ovn hxc_time_building_blocks.time_building_block_id%TYPE);

828: where timecard_id = p_timecard_id;
829:
830:
831: type rec_type is record(p_id hxc_time_building_blocks.time_building_block_id%TYPE,
832: p_ovn hxc_time_building_blocks.time_building_block_id%TYPE);
833:
834:
835: TYPE tab_type IS TABLE OF rec_type INDEX BY BINARY_INTEGER;
836:

Line 1024: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;

1020: funcmode IN varchar2,
1021: result IN OUT NOCOPY varchar2)
1022: is
1023:
1024: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
1025: l_app_bb_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
1026: l_action_code varchar2(30);
1027: l_recipient_code varchar2(30);
1028: l_approval_comp_id number;

Line 1025: l_app_bb_ovn hxc_time_building_blocks.time_building_block_id%TYPE;

1021: result IN OUT NOCOPY varchar2)
1022: is
1023:
1024: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
1025: l_app_bb_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
1026: l_action_code varchar2(30);
1027: l_recipient_code varchar2(30);
1028: l_approval_comp_id number;
1029: l_can_notify boolean;

Line 1030: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

1026: l_action_code varchar2(30);
1027: l_recipient_code varchar2(30);
1028: l_approval_comp_id number;
1029: l_can_notify boolean;
1030: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1031: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
1032: l_tc_from_role wf_local_roles.name%type;
1033: l_tc_to_role wf_local_roles.name%type;
1034: l_title varchar2(4000);

Line 1031: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;

1027: l_recipient_code varchar2(30);
1028: l_approval_comp_id number;
1029: l_can_notify boolean;
1030: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1031: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
1032: l_tc_from_role wf_local_roles.name%type;
1033: l_tc_to_role wf_local_roles.name%type;
1034: l_title varchar2(4000);
1035: l_total_hours number ;

Line 1045: l_resource_id hxc_time_building_blocks.resource_id%type;

1041: l_preparer_full_name per_all_people_f.full_name%type;
1042: l_fyi_subject varchar2(4000);
1043: l_description varchar2(4000);
1044: l_tc_url varchar2(1000);
1045: l_resource_id hxc_time_building_blocks.resource_id%type;
1046: l_effective_END_date date;
1047: l_effective_start_date date;
1048: l_tc_stop_date date;
1049: l_tc_start_date date;

Line 1065: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE

1061: l_exclude_hours varchar2(1) := 'N';
1062: l_proc constant varchar2(61) :=g_pkg||'Prepare Notifications';
1063:
1064: CURSOR c_tc_info(
1065: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE
1066: )
1067: IS
1068: SELECT tcsum.resource_id,
1069: tcsum.start_time,