APPS.JL_BR_SPED_PKG dependencies on RA_CUST_TRX_TYPES

Line 443: SELECT TYPE, DEFAULT_STATUS FROM ra_cust_trx_types WHERE cust_trx_type_id = p_type_id;

439: CURSOR C_trx_details( p_trx_id IN NUMBER ) IS
440: SELECT selected_for_receipt_batch_id, sum(amount_due_remaining) FROM ar_payment_schedules WHERE customer_trx_id = p_trx_id
441: GROUP BY customer_trx_id,selected_for_receipt_batch_id;
442: CURSOR C_CM_Details( p_type_id IN NUMBER ) IS
443: SELECT TYPE, DEFAULT_STATUS FROM ra_cust_trx_types WHERE cust_trx_type_id = p_type_id;
444: L_COUNTRY_CODE varchar2(30);
445: BEGIN
446: FND_PROFILE.GET ('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);
447: IF L_COUNTRY_CODE = 'BR' THEN