DBA Data[Home] [Help]

APPS.HXC_TIMECARD_UTIL dependencies on HXC_TIME_BUILDING_BLOCKS

Line 77: From hxc_time_building_blocks htb

73: Select 'exists'
74: From sys.dual
75: Where EXISTS (
76: Select 'x'
77: From hxc_time_building_blocks htb
78: Where htb.scope = 'TIMECARD'
79: And htb.type = 'RANGE'
80: And htb.date_to = hr_general.end_of_time
81: And htb.resource_type = 'PERSON'

Line 167: hxc_time_building_blocks htb

163: IS
164: select max(ht.transaction_date)
165: from hxc_dep_transactions ht,
166: hxc_dep_transaction_details htd,
167: hxc_time_building_blocks htb
168: where htb.parent_building_block_id = p_timecard_id
169: and htb.parent_building_block_ovn = p_timecard_ovn
170: and htb.scope = 'DAY'
171: and htd.time_building_block_id = htb.time_building_block_id

Line 185: hxc_time_building_blocks htb_day,

181: IS
182: select max(ht.transaction_date)
183: from hxc_dep_transactions ht,
184: hxc_dep_transaction_details htd,
185: hxc_time_building_blocks htb_day,
186: hxc_time_building_blocks htb_detail
187: where htb_day.parent_building_block_id = p_timecard_id
188: and htb_day.parent_building_block_ovn = p_timecard_ovn
189: and htb_day.scope = 'DAY'

Line 186: hxc_time_building_blocks htb_detail

182: select max(ht.transaction_date)
183: from hxc_dep_transactions ht,
184: hxc_dep_transaction_details htd,
185: hxc_time_building_blocks htb_day,
186: hxc_time_building_blocks htb_detail
187: where htb_day.parent_building_block_id = p_timecard_id
188: and htb_day.parent_building_block_ovn = p_timecard_ovn
189: and htb_day.scope = 'DAY'
190: and htb_detail.parent_building_block_id = htb_day.time_building_block_id