APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 258: hxc_time_attribute_usages au,

254: ,'N' NEW
255: ,'N' CHANGED
256: ,'N' PROCESS
257: from hxc_time_attributes a,
258: hxc_time_attribute_usages au,
259: hxc_bld_blk_info_types bbit
260: where au.time_building_block_id = p_detail_id
261: and au.time_building_block_ovn = p_detail_ovn
262: and au.time_attribute_id = a.time_attribute_id

Line 4202: from hxc_time_attribute_usages

4198: select attribute1, attribute2,
4199: attribute8, attribute9
4200: from hxc_time_attributes
4201: where time_attribute_id = (select min(time_attribute_id)
4202: from hxc_time_attribute_usages
4203: where time_building_block_id = p_app_bb_id
4204: and time_building_block_ovn = p_app_bb_ovn);
4205: */
4206: --

Line 4252: from hxc_time_attribute_usages

4248: attribute6 = l_approval_comment,
4249: attribute7 = l_approved_status,
4250: attribute8 = l_delegated_for
4251: where time_attribute_id in (select time_attribute_id
4252: from hxc_time_attribute_usages
4253: where time_building_block_id = p_app_bb_id
4254: and time_building_block_ovn = p_app_bb_ovn)
4255: and attribute3 = to_char(l_approver_id)
4256: and attribute_category = 'APPROVAL';

Line 5630: hxc_time_attribute_usages tau,

5626: --
5627: cursor csr_get_override_id is
5628: select to_number(ta.attribute10)
5629: from hxc_time_attributes ta,
5630: hxc_time_attribute_usages tau,
5631: hxc_time_building_blocks tbb
5632: where tbb.time_building_block_id = p_timecard_bb_id
5633: and tbb.object_version_number = p_timecard_ovn
5634: and tbb.time_building_block_id = tau.time_building_block_id