[Home] [Help]
3415: RETURN NUMBER
3416: IS
3417: cursor get_resp_id(p_resource_id IN NUMBER, p_evaluation_date IN DATE) is
3418: SELECT ta.attribute4 , ta.attribute3
3419: from HXC_TIME_ATTRIBUTES ta, HXC_TIME_ATTRIBUTE_USAGES tau, hxc_latest_details ld, hxc_timecard_summary tbd
3420: where ta.time_attribute_id = tau.time_attribute_id
3421: and tau.time_building_block_id = ld.time_building_block_id
3422: and tau.time_building_block_ovn = ld.object_version_number
3423: and ld.resource_id = p_resource_id
3490: order by ld.last_update_date DESC;
3491:
3492: cursor get_resp_id (detail_building_block_id IN NUMBER, detail_builiding_block_ovn IN NUMBER) IS
3493: SELECT ta.attribute4, ta.attribute5, ta.attribute3
3494: FROM HXC_TIME_ATTRIBUTES ta, HXC_TIME_ATTRIBUTE_USAGES tau
3495: WHERE ta.attribute_category = 'SECURITY'
3496: and ta.time_attribute_id = tau.time_attribute_id
3497: and tau.time_building_block_id = detail_building_block_id
3498: and tau.time_building_block_ovn = detail_builiding_block_ovn;
3690: IS SELECT ha.attribute4,
3691: ha.attribute5,
3692: ha.attribute3
3693: FROM hxc_time_attribute_usages hau,
3694: hxc_time_attributes ha
3695: WHERE hau.time_building_block_id = p_timecard_id
3696: AND hau.time_building_block_ovn = p_timecard_ovn
3697: AND ha.time_attribute_id = hau.time_attribute_id
3698: AND attribute_category = 'SECURITY' ;
3714: ha.attribute4,
3715: ha.attribute5,
3716: ha.attribute3
3717: FROM hxc_time_attribute_usages hau,
3718: hxc_time_attributes ha,
3719: hxc_latest_details hld
3720: WHERE hld.resource_id = p_resource_id
3721: AND TRUNC(hld.start_time) >= p_start_date
3722: AND TRUNC(hld.stop_time) <= TRUNC(p_stop_date)