APPS.JAI_AR_TAX_LINES_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 50: ra_customer_trx_lines_all trxl

46: PRAGMA AUTONOMOUS_TRANSACTION;
47: CURSOR check_trx_type IS
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

Line 94: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;

90: v_salesrep_id NUMBER;
91: v_line_type VARCHAR2(30);
92: v_vat_tax NUMBER;
93: v_ccid NUMBER;
94: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
95: v_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
96: v_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE;
97:
98: v_created_from VARCHAR2(30);

Line 95: v_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;

91: v_line_type VARCHAR2(30);
92: v_vat_tax NUMBER;
93: v_ccid NUMBER;
94: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
95: v_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
96: v_customer_trx_id RA_CUSTOMER_TRX_ALL.customer_trx_id%TYPE;
97:
98: v_created_from VARCHAR2(30);
99: c_from_currency_code VARCHAR2(15);