DBA Data[Home] [Help]

APPS.JAI_AR_TRX_PKG dependencies on JAI_CONSTANTS

Line 132: AND jror.attribute_type_code = jai_constants.regn_type_others

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
135: AND jror.location_id = jat.location_id
136: AND jat.customer_trx_id = cp_customer_trx_id;

Line 133: AND jror.attribute_code = jai_constants.attr_code_same_inv_no

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
135: AND jror.location_id = jat.location_id
136: AND jat.customer_trx_id = cp_customer_trx_id;
137: