APPS.CHV_CONFIRM_SCHEDULES dependencies on CHV_SCHEDULE_ITEMS

Line 46: UPDATE chv_schedule_items

42: --confirmed. Update the status and the standard who columns.
43:
44: x_progress := '020';
45:
46: UPDATE chv_schedule_items
47: SET item_confirm_status = 'CONFIRMED',
48: last_update_date = SYSDATE,
49: last_updated_by = x_user_id,
50: last_update_login = x_login_id

Line 155: FROM chv_schedule_items csi,

151: csi.item_confirm_status,
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