APPS.JAI_AP_TDS_PREPAYMENTS_PKG dependencies on JAI_AP_TDS_INVOICES

Line 416: update JAI_AP_TDS_INVOICES

412: goto exit_from_procedure;
413: end if;
414:
415: /* prepayment apply scenario for backward compatibility*/
416: update JAI_AP_TDS_INVOICES
417: set amt_reversed = nvl(amt_reversed, 0) - r_get_total_prepayment_tax.tds_amount,
418: amt_applied = nvl(amt_applied, 0) - abs(p_prepay_amount)
419: where invoice_id = p_invoice_id;
420: /* prepayment apply scenario for backward compatibility*/

Line 1348: update JAI_AP_TDS_INVOICES

1344: goto exit_from_procedure;
1345: end if;
1346:
1347: /* prepayment apply scenario for backward compatibility*/
1348: update JAI_AP_TDS_INVOICES
1349: set amt_reversed = nvl(amt_reversed, 0) + r_get_total_prepayment_tax.tds_amount,
1350: amt_applied = nvl(amt_applied, 0) + abs(p_prepay_amount)
1351: where invoice_id = p_invoice_id;
1352: /* prepayment apply scenario for backward compatibility*/

Line 1566: from JAI_AP_TDS_INVOICES

1562: is
1563:
1564: cursor c_tds_count(p_invoice_id number, p_source_attribute varchar2) is
1565: select count(1)
1566: from JAI_AP_TDS_INVOICES
1567: where invoice_id = p_invoice_id
1568: and source_attribute = p_source_attribute;
1569:
1570: /* Following cursor definition has been changed to cater for the obsoletion of table ja_in_ap_tds_inv_temp */