DBA Data[Home] [Help]

APPS.CHV_CONFIRM_SCHEDULES dependencies on CHV_CUM_PERIOD_ITEMS

Line 302: FROM chv_cum_period_items

298: --Select cum period item id for the supplier/site/item/org.
299:
300: SELECT cum_period_item_id
301: INTO x_cum_period_item_id
302: FROM chv_cum_period_items
303: WHERE cum_period_id = x_cum_period_id
304: AND vendor_id = x_vendor_id
305: AND vendor_site_id = x_vendor_site_id
306: AND item_id = x_item_id ;

Line 314: SELECT chv_cum_period_items_s.nextval

310: x_progress := '080' ;
311:
312: -- No cum period item record found so create a new one.
313:
314: SELECT chv_cum_period_items_s.nextval
315: INTO x_cum_period_item_id
316: FROM dual ;
317:
318: INSERT into chv_cum_period_items(cum_period_item_id,

Line 318: INSERT into chv_cum_period_items(cum_period_item_id,

314: SELECT chv_cum_period_items_s.nextval
315: INTO x_cum_period_item_id
316: FROM dual ;
317:
318: INSERT into chv_cum_period_items(cum_period_item_id,
319: cum_period_id,
320: organization_id,
321: vendor_id,
322: vendor_site_id,