APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 123: FROM RA_CUST_TRX_TYPES_ALL

119: ;
120:
121: CURSOR transaction_type_cur IS
122: SELECT TYPE
123: FROM RA_CUST_TRX_TYPES_ALL
124: WHERE cust_trx_type_id = pr_new.cust_trx_type_id
125: AND NVL(org_id,0) = NVL(pr_new.org_id,0);
126:
127: l_api_name CONSTANT VARCHAR2(30) := 'GEN_VAT_FOR_INV()';

Line 311: From RA_CUST_TRX_TYPES_ALL

307: v_ref_line_id varchar2(30);
308:
309: Cursor transaction_type_cur IS
310: Select type
311: From RA_CUST_TRX_TYPES_ALL
312: Where cust_trx_type_id = pr_new.cust_trx_type_id
313: And NVL(org_id,0) = NVL(pr_new.org_id,0);
314:
315: v_currency_code gl_sets_of_books.currency_code%type;

Line 764: FROM RA_CUST_TRX_TYPES_ALL

760: location_id = p_loc_id;
761:
762: CURSOR transaction_type_cur IS
763: SELECT TYPE
764: FROM RA_CUST_TRX_TYPES_ALL
765: WHERE cust_trx_type_id = pr_new.cust_trx_type_id
766: AND (org_id = pr_new.org_id
767: OR
768: (org_id is null and pr_new.org_id is null)) ;

Line 2135: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;

2131: */
2132: PROCEDURE process_cm_vat_repo ( pr_old t_jai_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
2133: v_organization_id NUMBER ;
2134: v_loc_id NUMBER ;
2135: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
2136: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE ;
2137: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
2138: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
2139: lv_process_flag VARCHAR2(10) ;

Line 2213: FROM ra_cust_trx_types_all

2209: */
2210: CURSOR transaction_type_cur
2211: IS
2212: SELECT type
2213: FROM ra_cust_trx_types_all
2214: WHERE cust_trx_type_id = pr_new.cust_trx_type_id AND
2215: NVL(org_id,0) = NVL(pr_new.org_id,0);
2216:
2217: