APPS.JL_ZZ_TAX dependencies on RA_CUSTOMER_TRX_ALL

Line 4009: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;

4005: l_org_id NUMBER;
4006: l_country_code varchar2(2);
4007:
4008: -- bug#6834705
4009: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
4010: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
4011:
4012:
4013: CURSOR get_orig_trx_type_id_c

Line 4010: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;

4006: l_country_code varchar2(2);
4007:
4008: -- bug#6834705
4009: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
4010: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
4011:
4012:
4013: CURSOR get_orig_trx_type_id_c
4014: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,

Line 4014: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,

4010: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
4011:
4012:
4013: CURSOR get_orig_trx_type_id_c
4014: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
4015: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
4016: IS
4017: SELECT cust_trx_type_id
4018: FROM RA_CUSTOMER_TRX_ALL

Line 4015: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)

4011:
4012:
4013: CURSOR get_orig_trx_type_id_c
4014: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
4015: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
4016: IS
4017: SELECT cust_trx_type_id
4018: FROM RA_CUSTOMER_TRX_ALL
4019: WHERE org_id = c_org_id

Line 4018: FROM RA_CUSTOMER_TRX_ALL

4014: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
4015: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
4016: IS
4017: SELECT cust_trx_type_id
4018: FROM RA_CUSTOMER_TRX_ALL
4019: WHERE org_id = c_org_id
4020: AND customer_trx_id = c_customer_trx_id ;
4021:
4022: BEGIN