513: change_reason VARCHAR2,
514: audit_history VARCHAR2
515: ) IS
516: SELECT 'Y'
517: FROM hxc_time_attributes
518: WHERE time_attribute_id IN (SELECT time_attribute_id
519: FROM hxc_time_attribute_usages
520: WHERE time_building_block_id = bb_id
521: AND time_building_block_ovn = bb_ovn)
528: bb_ovn NUMBER,
529: audit_history VARCHAR2
530: ) IS
531: SELECT 'Y'
532: FROM hxc_time_attributes
533: WHERE time_attribute_id IN (SELECT time_attribute_id
534: FROM hxc_time_attribute_usages
535: WHERE time_building_block_id = bb_id
536: AND time_building_block_ovn = bb_ovn)