301: */
302:
303: select sum(adjustment_quantity)
304: into x_adjustment_quantity
305: from chv_cum_adjustments cha,
306: chv_cum_periods ccp
307: where cha.organization_id = X_organization_id
308: and cha.vendor_id = X_vendor_id
309: and cha.vendor_site_id = X_vendor_site_id
514: ** will not find the record. Hence It has to be >= x_cum_period_end
515: */
516: select sum(adjustment_quantity)
517: into x_adjustment_quantity
518: from chv_cum_adjustments cha,
519: chv_cum_periods ccp
520: where cha.organization_id = X_organization_id
521: and cha.vendor_id = X_vendor_id
522: and cha.vendor_site_id = X_vendor_site_id