DBA Data[Home] [Help]

APPS.CHV_CUM_PERIODS_S1 dependencies on CHV_CUM_ADJUSTMENTS

Line 299: from chv_cum_adjustments cha,

295: */
296:
297: select sum(adjustment_quantity)
298: into x_adjustment_quantity
299: from chv_cum_adjustments cha,
300: chv_cum_periods ccp
301: where cha.organization_id = X_organization_id
302: and cha.vendor_id = X_vendor_id
303: and cha.vendor_site_id = X_vendor_site_id

Line 512: from chv_cum_adjustments cha,

508: ** will not find the record. Hence It has to be >= x_cum_period_end
509: */
510: select sum(adjustment_quantity)
511: into x_adjustment_quantity
512: from chv_cum_adjustments cha,
513: chv_cum_periods ccp
514: where cha.organization_id = X_organization_id
515: and cha.vendor_id = X_vendor_id
516: and cha.vendor_site_id = X_vendor_site_id