APPS.HXC_TIMECARD_SUMMARY_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 159: from hxc_time_attribute_usages tau, hxc_time_attributes ta

155: cursor c_reasons
156: (p_id in hxc_time_building_blocks.time_building_block_id%type
157: ) is
158: select 'Y'
159: from hxc_time_attribute_usages tau, hxc_time_attributes ta
160: where tau.time_building_block_id = p_id
161: and tau.time_Attribute_id = ta.time_attribute_Id
162: and ta.attribute_category = hxc_timecard.c_reason_attribute;
163:

Line 266: from hxc_time_attributes

262: and scope = 'TIMECARD';
263:
264: cursor c_check_for_reasons is
265: select 'Y'
266: from hxc_time_attributes
267: where attribute_category = hxc_timecard.c_reason_attribute;
268:
269: l_approval_status hxc_time_building_blocks.approval_status%type;
270: l_resource_id hxc_time_building_blocks.resource_id%type;