APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 21: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;

17: v_salesrep_id NUMBER;
18: v_line_type VARCHAR2(30);
19: v_vat_tax NUMBER;
20: v_ccid NUMBER;
21: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
22: /* commented by rallamse bug#4479131 PADDR Elimination
23: v_paddr v$session.paddr%TYPE;
24: */
25: v_customer_trx_line_id NUMBER; -- := pr_new.customer_trx_line_id; --Ramananda for File.Sql.35

Line 213: To populate Tax_rate column in RA_CUSTOMER_TRX_LINES_ALL

209: FILENAME: JA_IN_APPS_AR_LINES_INSERT_TRG.sql
210: CHANGE HISTORY:
211: S.No Date Author and Details
212: 1. 10-Jun-01 Jagdish / Subbu
213: To populate Tax_rate column in RA_CUSTOMER_TRX_LINES_ALL
214: table as receipts with discounts doesn't get saved.
215: 2. 2001/06/22 Anuradha Parthasarathy
216: Commented and Added code for better performance.
217:

Line 828: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;

824: v_salesrep_id NUMBER;
825: v_line_type VARCHAR2(30);
826: v_vat_tax NUMBER;
827: v_ccid NUMBER;
828: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
829: -- v_paddr v$session.paddr%TYPE;
-- bug#6842749
830: v_counter NUMBER;
831: v_customer_trx_id NUMBER; -- := pr_old.customer_trx_id; --rpokkula for File.Sql.35
832: c_from_currency_code VARCHAR2(15);

Line 859: from ra_customer_trx_lines_all

855: /*commented the above cursor and added the following for bug#5597146*/
856: cursor c_get_hdr_ctx
857: is
858: select distinct interface_line_context
859: from ra_customer_trx_lines_all
860: where customer_trx_id = pr_new.customer_trx_id
861: and customer_trx_line_id = pr_new.customer_trx_line_id --added for bug#5597146
862: and interface_line_context is not null
863: and rownum = 1;