APPS.HXC_TIMEKEEPER_PROCESS dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 519: FROM hxc_time_attribute_usages

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

Line 534: FROM hxc_time_attribute_usages

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