972: END IF;
973:
974: select sum(amount)
975: into l_ap_charge_distribution.rec_tax
976: from ap_invoice_distributions_all where
977: line_type_lookup_code = 'TAX' and
978: charge_applicable_to_dist_id = l_ap_charge_distribution.invoice_distribution_id;
979:
980: select sum(amount)
978: charge_applicable_to_dist_id = l_ap_charge_distribution.invoice_distribution_id;
979:
980: select sum(amount)
981: into l_ap_charge_distribution.nonrec_tax
982: from ap_invoice_distributions_all where
983: line_type_lookup_code = 'NONREC_TAX' and
984: charge_applicable_to_dist_id = l_ap_charge_distribution.invoice_distribution_id;
985:
986:
1128:
1129: END IF; --}
1130:
1131: -- update APs flag
1132: UPDATE ap_invoice_distributions_all
1133: SET rcv_charge_addition_flag = 'Y'
1134: WHERE invoice_distribution_id = l_ap_charge_distribution.invoice_distribution_id;
1135:
1136: