DBA Data[Home] [Help]

APPS.HXC_TPD_END dependencies on HXC_TIME_BUILDING_BLOCKS

Line 149: lv_start_time hxc_time_building_blocks.start_time%TYPE;

145: AND cp_period_start <= htb.stop_time
146: AND cp_period_end >= htb.start_time);
147:
148: p_message VARCHAR2 (30);
149: lv_start_time hxc_time_building_blocks.start_time%TYPE;
150: lv_stop_time hxc_time_building_blocks.stop_time%TYPE;
151: ld_period_start_date DATE;
152: ld_period_end_date DATE;
153: lv_row_found VARCHAR2 (1) := 'N';

Line 150: lv_stop_time hxc_time_building_blocks.stop_time%TYPE;

146: AND cp_period_end >= htb.start_time);
147:
148: p_message VARCHAR2 (30);
149: lv_start_time hxc_time_building_blocks.start_time%TYPE;
150: lv_stop_time hxc_time_building_blocks.stop_time%TYPE;
151: ld_period_start_date DATE;
152: ld_period_end_date DATE;
153: lv_row_found VARCHAR2 (1) := 'N';
154: lv_exists1 VARCHAR2 (1);