APPS.HXC_APPROVAL_REPORT_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 66: hxc_time_attributes hta_last_aprv

62: select max(htau_last_aprv.time_attribute_id ) INTO l_last_approver_id
63: from
64: hxc_time_building_blocks htb,
65: hxc_time_attribute_usages htau_last_aprv,
66: hxc_time_attributes hta_last_aprv
67: where
68: htb.time_building_block_id = p_timecard_id
69: and htb.object_version_number = p_timecard_ovn
70: and htb.time_building_block_id = htau_last_aprv.time_building_block_id

Line 78: select attribute3 into l_last_approver from hxc_time_attributes

74: and hta_last_aprv.attribute4 = 'FINISHED' ;
75:
76: if (l_last_approver_id is not null)
77: then
78: select attribute3 into l_last_approver from hxc_time_attributes
79: where time_attribute_id = l_last_approver_id ;
80: end if;
81:
82: return l_last_approver;