538: change_reason VARCHAR2,
539: audit_history VARCHAR2
540: ) IS
541: SELECT 'Y'
542: FROM hxc_time_attributes
543: WHERE time_attribute_id IN (SELECT time_attribute_id
544: FROM hxc_time_attribute_usages
545: WHERE time_building_block_id = bb_id
546: AND time_building_block_ovn = bb_ovn)
553: bb_ovn NUMBER,
554: audit_history VARCHAR2
555: ) IS
556: SELECT 'Y'
557: FROM hxc_time_attributes
558: WHERE time_attribute_id IN (SELECT time_attribute_id
559: FROM hxc_time_attribute_usages
560: WHERE time_building_block_id = bb_id
561: AND time_building_block_ovn = bb_ovn)