APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 381: hxc_time_attribute_usages au,

377: ,'N' NEW
378: ,'N' CHANGED
379: ,'N' PROCESS
380: from hxc_time_attributes a,
381: hxc_time_attribute_usages au,
382: hxc_bld_blk_info_types bbit
383: where au.time_building_block_id = p_detail_id
384: and au.time_building_block_ovn = p_detail_ovn
385: and au.time_attribute_id = a.time_attribute_id

Line 4854: from hxc_time_attribute_usages

4850: select attribute1, attribute2,
4851: attribute8, attribute9
4852: from hxc_time_attributes
4853: where time_attribute_id = (select min(time_attribute_id)
4854: from hxc_time_attribute_usages
4855: where time_building_block_id = p_app_bb_id
4856: and time_building_block_ovn = p_app_bb_ovn);
4857: */
4858: --

Line 4904: from hxc_time_attribute_usages

4900: attribute6 = l_approval_comment,
4901: attribute7 = l_approved_status,
4902: attribute8 = l_delegated_for
4903: where time_attribute_id in (select time_attribute_id
4904: from hxc_time_attribute_usages
4905: where time_building_block_id = p_app_bb_id
4906: and time_building_block_ovn = p_app_bb_ovn)
4907: and attribute3 = to_char(l_approver_id)
4908: and attribute_category = 'APPROVAL';

Line 6317: hxc_time_attribute_usages tau,

6313: --
6314: cursor csr_get_override_id is
6315: select to_number(ta.attribute10)
6316: from hxc_time_attributes ta,
6317: hxc_time_attribute_usages tau,
6318: hxc_time_building_blocks tbb
6319: where tbb.time_building_block_id = p_timecard_bb_id
6320: and tbb.object_version_number = p_timecard_ovn
6321: and tbb.time_building_block_id = tau.time_building_block_id