DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIME_DEPOSIT dependencies on HXC_TIME_SOURCES

Line 3891: l_time_source_id hxc_time_sources.time_source_id%TYPE;

3887: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
3888: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3889: l_max_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3890: l_deposit_process_id NUMBER;
3891: l_time_source_id hxc_time_sources.time_source_id%TYPE;
3892: l_time_source_name hxc_time_sources.name%TYPE;
3893: l_timecard hxc_time_attributes_api.timecard;
3894: l_attribute_index NUMBER;
3895: l_bld_blk_info_type_id NUMBER;

Line 3892: l_time_source_name hxc_time_sources.name%TYPE;

3888: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3889: l_max_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3890: l_deposit_process_id NUMBER;
3891: l_time_source_id hxc_time_sources.time_source_id%TYPE;
3892: l_time_source_name hxc_time_sources.name%TYPE;
3893: l_timecard hxc_time_attributes_api.timecard;
3894: l_attribute_index NUMBER;
3895: l_bld_blk_info_type_id NUMBER;
3896: l_mapping_comp_usage_id NUMBER;

Line 4035: FROM hxc_time_sources ts

4031: -- get the deposit process id
4032:
4033: SELECT dp.deposit_process_id, dp.time_source_id, ts.name
4034: INTO l_deposit_process_id, l_time_source_id, l_time_source_name
4035: FROM hxc_time_sources ts
4036: , hxc_deposit_processes dp
4037: WHERE dp.name = p_deposit_process -- GPM v115.42
4038: AND ts.time_source_id = dp.time_source_id;
4039: