APPS.CHV_INQ_SV dependencies on CHV_HORIZ_DATE_SCHEDULES_V

Line 98: start_date_rec chv_horiz_date_schedules_v%rowtype ;

94: p_bucket_start_date IN OUT NOCOPY DATE,
95: p_bucket_end_date IN OUT NOCOPY DATE) IS
96:
97: bucket_rec chv_horizontal_schedules%rowtype ;
98: start_date_rec chv_horiz_date_schedules_v%rowtype ;
99: end_date_rec chv_horiz_date_schedules_v%rowtype ;
100:
101: BEGIN
102:

Line 99: end_date_rec chv_horiz_date_schedules_v%rowtype ;

95: p_bucket_end_date IN OUT NOCOPY DATE) IS
96:
97: bucket_rec chv_horizontal_schedules%rowtype ;
98: start_date_rec chv_horiz_date_schedules_v%rowtype ;
99: end_date_rec chv_horiz_date_schedules_v%rowtype ;
100:
101: BEGIN
102:
103: SELECT *

Line 112: FROM chv_horiz_date_schedules_v

108: AND row_select_order = 1 ;
109:
110: SELECT *
111: INTO start_date_rec
112: FROM chv_horiz_date_schedules_v
113: WHERE schedule_id = p_schedule_id
114: AND schedule_item_id = p_schedule_item_id
115: AND row_select_order = 2 ;
116:

Line 119: FROM chv_horiz_date_schedules_v

115: AND row_select_order = 2 ;
116:
117: SELECT *
118: INTO end_date_rec
119: FROM chv_horiz_date_schedules_v
120: WHERE schedule_id = p_schedule_id
121: AND schedule_item_id = p_schedule_item_id
122: AND row_select_order = 7 ;
123: