DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on JAI_AP_TDS_PREPAYMENTS

Line 97: from jai_ap_tds_prepayments

93: and aida.line_type_lookup_code = 'PREPAY'
94: and aida.amount > 0
95: and aida.prepay_distribution_id is not null
96: and not exists (select 1
97: from jai_ap_tds_prepayments
98: where invoice_id = cp_trx_id
99: and invoice_distribution_id_prepay = aida.parent_reversal_id
100: and unapply_flag = 'Y');
101:

Line 631: from jai_ap_tds_prepayments

627: and line_type_lookup_code = 'PREPAY'
628: and amount < 0
629: and prepay_distribution_id is not null
630: and not exists (select 1
631: from jai_ap_tds_prepayments
632: where invoice_id = cp_trx_id
633: and invoice_distribution_id_prepay = aida.invoice_distribution_id);
634:
635: begin