DBA Data[Home] [Help]

APPS.JAI_AR_TRX_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 196: FROM JAI_RGM_ORG_REGNS_V jror, jai_ar_trxs jat

192: --added for bug#6685050,csahoo
193: CURSOR c_same_inv_no (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type)
194: IS
195: SELECT jror.attribute_Value
196: FROM JAI_RGM_ORG_REGNS_V jror, jai_ar_trxs jat
197: WHERE regime_code = 'VAT'
198: AND jror.attribute_type_code = jai_constants.regn_type_others
199: AND jror.attribute_code = jai_constants.attr_code_same_inv_no
200: AND jror.organization_id = jat.organization_id