DBA Data[Home] [Help]

APPS.HXC_TPD_END dependencies on HXC_TIME_BUILDING_BLOCKS

Line 131: lv_start_time hxc_time_building_blocks.start_time%TYPE;

127: AND cp_period_start <= htb.stop_time
128: AND cp_period_end >= htb.start_time);
129:
130: p_message VARCHAR2 (30);
131: lv_start_time hxc_time_building_blocks.start_time%TYPE;
132: lv_stop_time hxc_time_building_blocks.stop_time%TYPE;
133: ld_period_start_date DATE;
134: ld_period_end_date DATE;
135: lv_row_found VARCHAR2 (1) := 'N';

Line 132: lv_stop_time hxc_time_building_blocks.stop_time%TYPE;

128: AND cp_period_end >= htb.start_time);
129:
130: p_message VARCHAR2 (30);
131: lv_start_time hxc_time_building_blocks.start_time%TYPE;
132: lv_stop_time hxc_time_building_blocks.stop_time%TYPE;
133: ld_period_start_date DATE;
134: ld_period_end_date DATE;
135: lv_row_found VARCHAR2 (1) := 'N';
136: lv_exists1 VARCHAR2 (1);