APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_TDS_THHOLD_TRXS

Line 88: based on the taxable_amount of jai_ap_tds_thhold_trxs table.

84: Added a call to the Concurrent JAINTDSA in the quarterly_returns procedure.
85:
86:
87: Added the update clause to modify the taxabale_amount of ja_in_ap_etds_temp
88: based on the taxable_amount of jai_ap_tds_thhold_trxs table.
89: In case of threshold transition and rollback transactions, the
90: taxable amount should be 0 for the differential invoice that has been created.
91: Hence, implemented this change.
92:

Line 760: from JAI_AP_TDS_THHOLD_TRXS b

756: -- start 5647248
757: update jai_ap_etds_t a
758: set base_taxabale_amount =
759: ( select nvl(taxable_amount,0)
760: from JAI_AP_TDS_THHOLD_TRXS b
761: where b.invoice_to_tds_authority_id = a.tds_invoice_id )
762: where a.batch_id = p_batch_id
763: and exists
764: ( select 1

Line 765: from JAI_AP_TDS_THHOLD_TRXS c

761: where b.invoice_to_tds_authority_id = a.tds_invoice_id )
762: where a.batch_id = p_batch_id
763: and exists
764: ( select 1
765: from JAI_AP_TDS_THHOLD_TRXS c
766: where c.invoice_to_tds_authority_id = a.tds_invoice_id
767: and c.tds_event like '%THRESHOLD%'
768: ) ;
769: -- end 5647248