APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 446: JAI_RGM_REGISTRATIONS

442: IS
443: SELECT
444: 1
445: FROM
446: JAI_RGM_REGISTRATIONS
447: WHERE
448: regime_id = cp_regime_id AND
449: upper(registration_type) = upper(jai_constants.regn_type_tax_types) AND
450: upper(attribute_code) = upper(cp_tax_type);

Line 4647: FROM jai_rgm_registrations

4643: /*--Commented by zhiwei.hou for POT code port
4644: CURSOR c_get_st_accrual_date
4645: IS
4646: SELECT to_date(attribute_value, 'DD/MM/YYYY')
4647: FROM jai_rgm_registrations
4648: WHERE regime_id = (select regime_id
4649: from JAI_RGM_DEFINITIONS
4650: where regime_code = jai_constants.service_regime)
4651: AND attribute_code = 'EFF_DATE_ST_PT'

Line 5106: cp_attribute_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE ,

5102: AND nvl(jtc.INCLUSIVE_TAX_FLAG,'N') = cp_inclusive_tax_flag
5103: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash;
5104:
5105: CURSOR c_get_rgm_attribute ( cp_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
5106: cp_attribute_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE ,
5107: cp_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE ,
5108: cp_location_id JAI_RGM_PARTIES.LOCATION_ID%TYPE
5109: )
5110: IS

Line 5185: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

5181: FROM
5182: dual;
5183:
5184: lv_member_name VARCHAR2(80);
5185: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5186: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5187: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
5188: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5189: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE;

Line 5186: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

5182: dual;
5183:
5184: lv_member_name VARCHAR2(80);
5185: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5186: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5187: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
5188: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5189: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE;
5190: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;

Line 5188: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

5184: lv_member_name VARCHAR2(80);
5185: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5186: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5187: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
5188: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5189: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE;
5190: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5191: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;
5192: lv_trx_number_prefix RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;