DBA Data[Home] [Help]

APPS.HXC_TC_AP_LINKS_PKG dependencies on HXC_APP_PERIOD_SUMMARY

Line 57: from hxc_app_period_summary

53: ,p_start_time in hxc_time_building_blocks.start_time%type
54: ,p_stop_time in hxc_time_building_blocks.stop_time%type
55: ) is
56: select application_period_id
57: from hxc_app_period_summary
58: where resource_id = p_resource_id
59: and start_time <= p_stop_time
60: and stop_time >= p_start_time;
61:

Line 117: from hxc_app_period_summary

113: cursor c_app_period_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
114: select resource_id
115: ,start_time
116: ,stop_time
117: from hxc_app_period_summary
118: where application_period_id = p_id;
119:
120: cursor c_timecards(p_resource_id in hxc_time_building_blocks.resource_id%type
121: ,p_start_time in hxc_time_building_blocks.start_time%type