APPS.AP_WITHHOLDING_PKG dependencies on AP_AWT_BUCKETS_ALL

Line 3916: UPDATE ap_awt_buckets_all

3912: CLOSE c_get_awt_period;
3913:
3914:
3915:
3916: UPDATE ap_awt_buckets_all
3917: SET gross_amount_to_date = gross_amount_to_date -
3918: NVL(rec_temp_gross.gross_amount,0)
3919: , last_UPDATE_date = SYSDATE
3920: , last_UPDATEd_by = P_Last_Updated_By

Line 4002: UPDATE ap_awt_buckets_all

3998: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
3999: END IF;
4000:
4001: --Bug12594549 commented gross amount update
4002: UPDATE ap_awt_buckets_all
4003: /* SET gross_amount_to_date = gross_amount_to_date -
4004: NVL(rec_temp.gross_amount,0) */
4005: SET withheld_amount_to_date = withheld_amount_to_date -
4006: NVL(rec_temp.withholding_amount,0)

Line 5824: UPDATE ap_awt_buckets_all

5820: CLOSE c_get_awt_period;
5821:
5822: END;
5823:
5824: UPDATE ap_awt_buckets_all
5825: SET
5826: withheld_amount_to_date = withheld_amount_to_date -
5827: NVL(rec_orphan_awt_buckets_w.withholding_amount, 0),
5828: last_update_date = SYSDATE,

Line 5891: UPDATE ap_awt_buckets_all

5887: CLOSE c_get_awt_period;
5888:
5889: END;
5890:
5891: UPDATE ap_awt_buckets_all
5892: SET
5893: gross_amount_to_date = gross_amount_to_date -
5894: NVL(rec_orphan_awt_buckets_g.gross_amount, 0),
5895: last_update_date = SYSDATE,