DBA Data[Home] [Help]

APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_RGM_DEFINITIONS

Line 53: , jai_rgm_definitions jrd

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
57: AND jail.invoice_line_number = pr_new.invoice_line_number

Line 70: , jai_rgm_definitions jrd

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
74: and jamt.invoice_distribution_id=nvl(pr_new.parent_reversal_id,pr_new.invoice_distribution_id) /* Added for bug 16393213 */

Line 112: FROM jai_rgm_definitions

108: WHERE invoice_id = pr_new.invoice_id ;
109:
110: CURSOR get_regime_id_cur IS
111: SELECT regime_id
112: FROM jai_rgm_definitions
113: WHERE regime_code = jai_constants.service_regime;
114:
115: CURSOR get_org_cur IS
116: SELECT organization_id,location_id