DBA Data[Home] [Help]

APPS.CHV_CUM_PERIODS_S1 dependencies on CHV_CUM_ADJUSTMENTS

Line 305: from chv_cum_adjustments cha,

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

Line 518: from chv_cum_adjustments cha,

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