DBA Data[Home] [Help]

APPS.JAI_AR_TRX_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 130: FROM JAI_RGM_ORG_REGNS_V jror, jai_ar_trxs jat

126: --added for bug#6685050,csahoo
127: CURSOR c_same_inv_no (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type)
128: IS
129: SELECT jror.attribute_Value
130: FROM JAI_RGM_ORG_REGNS_V jror, jai_ar_trxs jat
131: WHERE regime_code = 'VAT'
132: AND jror.attribute_type_code = jai_constants.regn_type_others
133: AND jror.attribute_code = jai_constants.attr_code_same_inv_no
134: AND jror.organization_id = jat.organization_id