1002: END IF;
1003:
1004: select sum(amount)
1005: into l_ap_charge_distribution.rec_tax
1006: from ap_invoice_distributions_all where
1007: line_type_lookup_code = 'TAX' and
1008: charge_applicable_to_dist_id = l_ap_charge_distribution.invoice_distribution_id;
1009:
1010: select sum(amount)
1008: charge_applicable_to_dist_id = l_ap_charge_distribution.invoice_distribution_id;
1009:
1010: select sum(amount)
1011: into l_ap_charge_distribution.nonrec_tax
1012: from ap_invoice_distributions_all where
1013: line_type_lookup_code = 'NONREC_TAX' and
1014: charge_applicable_to_dist_id = l_ap_charge_distribution.invoice_distribution_id;
1015:
1016:
1158:
1159: END IF; --}
1160:
1161: -- update APs flag
1162: UPDATE ap_invoice_distributions_all
1163: SET rcv_charge_addition_flag = 'Y'
1164: WHERE invoice_distribution_id = l_ap_charge_distribution.invoice_distribution_id;
1165:
1166: