DBA Data[Home] [Help]

APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 52: , jai_rgm_registrations jrr

48: SELECT jcta.tax_type
49: FROM jai_cmn_document_taxes jcdt
50: , jai_cmn_taxes_all jcta
51: , jai_ap_invoice_lines jail
52: , jai_rgm_registrations jrr
53: , jai_rgm_definitions jrd
54: WHERE jcdt.source_doc_id = pr_new.invoice_id
55: AND jail.invoice_id = pr_new.invoice_id
56: AND jail.invoice_line_number = jcdt.source_doc_line_id

Line 69: , jai_rgm_registrations jrr

65: CURSOR get_matched_tax_cur IS
66: SELECT jcta.tax_type
67: FROM jai_ap_match_inv_taxes jamt
68: , jai_cmn_taxes_all jcta
69: , jai_rgm_registrations jrr
70: , jai_rgm_definitions jrd
71: WHERE jamt.invoice_id = pr_new.invoice_id
72: AND jamt.invoice_line_number = pr_new.invoice_line_number
73: AND jamt.tax_id=jcta.tax_id