DBA Data[Home] [Help]

APPS.CHV_CONFIRM_SCHEDULES dependencies on CHV_CUM_PERIODS

Line 223: FROM chv_cum_periods ccp

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:

Line 251: FROM chv_cum_periods ccp

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;