DBA Data[Home] [Help]

APPS.GMS_AWARDS_DIST_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 280: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL

276: from gms_award_distributions
277: where award_set_id = x_new_award_set_id
278: ) ;
279: /* BUG 14216205 : Added the following Code for SAT : Starts */
280: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL
281: set award_id = x_new_award_set_id
282: WHERE invoice_id = p_invoice_id
283: and invoice_distribution_id = p_dist_id
284: and exists ( select 'X'

Line 304: from AP_SELF_ASSESSED_TAX_DIST_ALL

300:
301: /* BUG 14216205 : Added the following Code for SAT : Starts */
302: UPDATE gms_award_distributions
303: set distribution_line_number = (select distribution_line_number
304: from AP_SELF_ASSESSED_TAX_DIST_ALL
305: where invoice_id = p_invoice_id
306: and invoice_distribution_id = p_dist_id
307: and award_id = x_new_award_set_id )
308: where award_set_id = x_new_award_set_id