219: BEGIN
220:
221: SELECT 'Y'
222: INTO x_open_cum_period
223: FROM chv_cum_periods ccp
224: WHERE x_schedule_horizon_start between ccp.cum_period_start_date
225: and ccp.cum_period_end_date
226: AND ccp.organization_id = x_item_org_id;
227:
247: x_progress := '050' ;
248:
249: SELECT ccp.cum_period_id
250: INTO x_cum_period_id
251: FROM chv_cum_periods ccp
252: WHERE x_schedule_horizon_start
253: BETWEEN ccp.cum_period_start_date
254: AND ccp.cum_period_end_date
255: AND ccp.organization_id = x_item_org_id;