DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on JAI_AP_INVOICE_LINES

Line 1532: , jai_ap_invoice_lines jail

1528: CURSOR get_tax_type_cur IS
1529: SELECT jcta.tax_type
1530: FROM jai_cmn_document_taxes jcdt
1531: , jai_cmn_taxes_all jcta
1532: , jai_ap_invoice_lines jail
1533: , jai_rgm_registrations jrr
1534: , jai_rgm_definitions jrd
1535: WHERE jcdt.source_doc_id = pr_rec.invoice_id
1536: AND jail.invoice_id = pr_rec.invoice_id

Line 1590: FROM jai_ap_invoice_lines

1586: WHERE regime_code = jai_constants.service_regime;
1587:
1588: CURSOR get_org_cur IS
1589: SELECT organization_id,location_id
1590: FROM jai_ap_invoice_lines
1591: WHERE invoice_id = pr_rec.invoice_id
1592: AND invoice_line_number = (SELECT parent_invoice_line_number
1593: FROM jai_ap_invoice_lines jail
1594: WHERE jail.invoice_line_number = pr_rec.invoice_line_number

Line 1593: FROM jai_ap_invoice_lines jail

1589: SELECT organization_id,location_id
1590: FROM jai_ap_invoice_lines
1591: WHERE invoice_id = pr_rec.invoice_id
1592: AND invoice_line_number = (SELECT parent_invoice_line_number
1593: FROM jai_ap_invoice_lines jail
1594: WHERE jail.invoice_line_number = pr_rec.invoice_line_number
1595: AND jail.invoice_id = pr_rec.invoice_id)
1596: AND parent_invoice_line_number IS NULL;
1597: