APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 13: , ra_cust_trx_types_all trx_types

9: SELECT trx_types.type
10: FROM
11: ra_customer_trx_lines_all trxl
12: , ra_customer_trx_all trx
13: , ra_cust_trx_types_all trx_types
14: WHERE trxl.customer_trx_id = trx.customer_trx_id
15: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
16: AND trxl.customer_trx_line_id = pn_customer_trx_line_id;
17:

Line 18: lv_trx_type ra_cust_trx_types_all.type%TYPE;

14: WHERE trxl.customer_trx_id = trx.customer_trx_id
15: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
16: AND trxl.customer_trx_line_id = pn_customer_trx_line_id;
17:
18: lv_trx_type ra_cust_trx_types_all.type%TYPE;
19: BEGIN
20: OPEN check_trx_type;
21: FETCH check_trx_type
22: INTO lv_trx_type;

Line 401: lv_trx_type ra_cust_trx_types_all.type%TYPE; --Added by Wenqiong for Bug 14253668

397:
398: ln_tax_type_code varchar2(50);
399: ------------------------------------------------------------------
400: -- Added by zhiwei for GST get ccid by regime setup BUG#10233402 20101027 END
401: lv_trx_type ra_cust_trx_types_all.type%TYPE; --Added by Wenqiong for Bug 14253668
402:
403: BEGIN
404: pv_return_code := jai_constants.successful ;
405: /*------------------------------------------------------------------------------------------

Line 1406: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

1402: WHERE REGIME_CODE = CP_REGIME_CODE;
1403:
1404: Cursor transaction_type_cur IS
1405: Select a.type
1406: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
1407: Where a.cust_trx_type_id = b.cust_trx_type_id
1408: And b.customer_trx_id = v_customer_trx_id
1409: And NVL(a.org_id,0) = NVL(b.org_id,0);
1410:

Line 1618: lv_trx_type ra_cust_trx_types_all.type%TYPE; --Added by Wenqiong for Bug 14253668

1614: SELECT NVL(minimum_accountable_unit,NVL(precision,2)) curr_precision
1615: FROM fnd_currencies
1616: WHERE currency_code = cp_currency_code;
1617:
1618: lv_trx_type ra_cust_trx_types_all.type%TYPE; --Added by Wenqiong for Bug 14253668
1619: --added the function for bug#8310220
1620: FUNCTION get_hdr_ctx (p_customer_trx_id IN NUMBER,
1621: p_customer_trx_line_id IN NUMBER)
1622: RETURN VARCHAR2