16:
17: l_level VARCHAR2(50);
18:
19: -- Bug 9662707
20: -- Replaced hxc_timecard_summary with hxc_time_building_blocks
21: -- picking up OVN instead of status. Status would be updated later.
22:
23: -- Bug 9656063
24: -- Added Asg Org search criteria
797: CURSOR get_summary
798: IS SELECT sum.approval_status,
799: rdb.timecard_id
800: FROM hxc_rdb_post_timecards rdb,
801: hxc_timecard_summary sum
802: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
803: AND rdb.timecard_id = sum.timecard_id;
804:
805:
823: sum.timecard_id,
824: sum.approval_status,
825: ROWIDTOCHAR(rdb.rowid)
826: FROM hxc_rdb_post_timecards rdb,
827: hxc_timecard_summary sum
828: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
829: AND rdb.approval_status = 'RDBDELETED'
830: AND rdb.resource_id = sum.resource_id
831: AND rdb.start_time = sum.start_time
845:
846:
847: BEGIN
848:
849: -- Update from hxc_timecard_summary for those in there.
850:
851: OPEN get_summary;
852: LOOP
853: FETCH get_summary BULK COLLECT INTO stattab,