APPS.HXC_TIMEKEEPER_PROCESS dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 544: FROM hxc_time_attribute_usages

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)
547: AND attribute_category = 'REASON'
548: AND attribute1 = DECODE (attribute3, 'CHANGE', change_reason, 'LATE', late_reason)

Line 559: FROM hxc_time_attribute_usages

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)
562: AND attribute_category = 'REASON'
563: AND attribute7 = DECODE (audit_history, NULL, attribute7, audit_history);