APPS.JAI_AR_TAX_LINES_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 52: , ra_cust_trx_types_all trx_types

48: SELECT trx_types.type
49: FROM
50: ra_customer_trx_lines_all trxl
51: , ra_customer_trx_all trx
52: , ra_cust_trx_types_all trx_types
53: WHERE trxl.customer_trx_id = trx.customer_trx_id
54: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
55: AND trxl.customer_trx_line_id = pn_customer_trx_line_id;
56:

Line 57: lv_trx_type ra_cust_trx_types_all.type%TYPE;

53: WHERE trxl.customer_trx_id = trx.customer_trx_id
54: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
55: AND trxl.customer_trx_line_id = pn_customer_trx_line_id;
56:
57: lv_trx_type ra_cust_trx_types_all.type%TYPE;
58: BEGIN
59: OPEN check_trx_type;
60: FETCH check_trx_type
61: INTO lv_trx_type;

Line 127: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

123: b.org_id,
124: b.bill_to_customer_id,
125: NVL(b.bill_to_site_use_id, 0),
126: b.trx_date
127: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
128: Where a.cust_trx_type_id = b.cust_trx_type_id
129: And b.customer_trx_id = v_customer_trx_id
130: And NVL(a.org_id, 0) = NVL(b.org_id, 0);
131:

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

317: lv_process_message VARCHAR2(1996);
318: l_max_tax_line_no NUMBER;
319: ln_tax_amount NUMBER;
320:
321: lv_trx_type ra_cust_trx_types_all.type%TYPE; --Added by Wenqiong for Bug 14253668
322: BEGIN
323:
324: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
325: lv_debug_info := 'JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_TEMP.BEGIN';