APPS.CHV_CONFIRM_SCHEDULES dependencies on CHV_SCHEDULE_HEADERS

Line 156: chv_schedule_headers csh,

152: csi.primary_unit_of_measure,
153: csi.purchasing_unit_of_measure,
154: coo.enable_cum_flag
155: FROM chv_schedule_items csi,
156: chv_schedule_headers csh,
157: chv_org_options coo
158: WHERE csi.schedule_id = p_schedule_id
159: AND csi.schedule_id = csh.schedule_id
160: AND csi.organization_id = coo.organization_id ;

Line 385: UPDATE chv_schedule_headers

381:
382: -- All the items have been successfully confirmed so
383: -- confirm the schedule header.
384:
385: UPDATE chv_schedule_headers
386: SET schedule_status = 'CONFIRMED',
387: confirm_date = SYSDATE,
388: last_update_date = SYSDATE,
389: last_updated_by = x_user_id,