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'
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