APPS.JL_ZZ_TAX dependencies on RA_CUSTOMER_TRX_ALL

Line 3921: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;

3917: l_org_id NUMBER;
3918: l_country_code varchar2(2);
3919:
3920: -- bug#6834705
3921: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
3922: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
3923:
3924:
3925: CURSOR get_orig_trx_type_id_c

Line 3922: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;

3918: l_country_code varchar2(2);
3919:
3920: -- bug#6834705
3921: l_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
3922: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
3923:
3924:
3925: CURSOR get_orig_trx_type_id_c
3926: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,

Line 3926: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,

3922: l_cust_trx_type_id RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID%TYPE;
3923:
3924:
3925: CURSOR get_orig_trx_type_id_c
3926: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
3927: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
3928: IS
3929: SELECT cust_trx_type_id
3930: FROM RA_CUSTOMER_TRX_ALL

Line 3927: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)

3923:
3924:
3925: CURSOR get_orig_trx_type_id_c
3926: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
3927: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
3928: IS
3929: SELECT cust_trx_type_id
3930: FROM RA_CUSTOMER_TRX_ALL
3931: WHERE org_id = c_org_id

Line 3930: FROM RA_CUSTOMER_TRX_ALL

3926: (c_org_id RA_CUSTOMER_TRX_ALL.org_id%TYPE,
3927: c_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE)
3928: IS
3929: SELECT cust_trx_type_id
3930: FROM RA_CUSTOMER_TRX_ALL
3931: WHERE org_id = c_org_id
3932: AND customer_trx_id = c_customer_trx_id ;
3933:
3934: BEGIN