APPS.HXC_TIMECARD_SUMMARY_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 158: from hxc_time_attribute_usages tau, hxc_time_attributes ta

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

Line 265: from hxc_time_attributes

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