APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_CMN_TAXES_ALL

Line 942: FROM JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c

938: CURSOR c_tax_dist_dtl(cp_regime_id IN NUMBER, cp_invoice_id IN NUMBER, cp_inv_distribution_id IN NUMBER) IS -- cp_dist_line_no IN NUMBER) IS
939: SELECT 1 chk, a.tax_id, b.tax_rate, a.tax_amount, a.parent_invoice_distribution_id, b.tax_type,
940: a.invoice_line_number, /* INVOICE LINES UPTAKE */
941: nvl(b.mod_cr_percentage,0) recoverable_ptg, a.base_amount
942: FROM JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c
943: WHERE a.invoice_id = cp_invoice_id
944: -- AND a.distribution_line_number = cp_dist_line_no Modified as part of AP INVOICE Lines Uptake project
945: AND a.invoice_distribution_id = cp_inv_distribution_id
946: AND a.tax_id = b.tax_id

Line 962: FROM jai_rcv_tp_inv_details a , JAI_CMN_TAXES_ALL b , jai_rcv_tp_invoices c, JAI_RGM_REGISTRATIONS d

958: CURSOR c_tp_inv_details (cp_regime_id IN NUMBER , cp_invoice_id IN NUMBER , cp_line_number IN NUMBER) IS
959: SELECT 1 chk , a.tax_id , a.tax_rate , a.tax_amount , NULL ,a.tax_type ,
960: a.line_number invoice_line_number, /* INVOICE LINES UPTAKE */
961: NVL(b.mod_cr_percentage,0) recoverable_ptg, NULL
962: FROM jai_rcv_tp_inv_details a , JAI_CMN_TAXES_ALL b , jai_rcv_tp_invoices c, JAI_RGM_REGISTRATIONS d
963: WHERE c.invoice_id = cp_invoice_id
964: AND a.batch_invoice_id = c.batch_invoice_id
965: AND a.tax_id = b.tax_id
966: AND a.line_number = cp_line_number /*INVOICE LINES UPTAKE cp_dist_line_number */