APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 131: FROM ra_cust_trx_line_gl_dist_all

127: );
128:
129: CURSOR c_get_trx_date IS
130: SELECT gl_date --Xiao for POT changes, reg bug#12533434
131: FROM ra_cust_trx_line_gl_dist_all
132: WHERE customer_trx_id = v_customer_trx_id
133: AND customer_trx_line_id = v_customer_trx_line_id
134: AND account_class = 'REV';--Xiao for POT changes, reg bug#12533434
135: -------------------------------------------------------------------------------------------------------------------

Line 1387: FROM ra_cust_trx_line_gl_dist_all

1383:
1384: CURSOR c_get_trx_date
1385: IS
1386: SELECT gl_date --Xiao for POT changes, reg bug#12533434
1387: FROM ra_cust_trx_line_gl_dist_all
1388: WHERE customer_trx_id = v_customer_trx_id
1389: AND customer_trx_line_id = pr_new.customer_trx_line_id
1390: AND account_class = 'REV';--Xiao for POT changes, reg bug#12533434
1391: ---------------------------------------------------------------------------------------------------------

Line 1535: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

1531:
1532: --commented the above org_cur cursor and added the following org_cur cursor for bug#5597146
1533: CURSOR ORG_CUR IS
1534: SELECT ORG_ID
1535: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
1536: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id
1537: AND account_class ='REC'
1538: AND latest_rec_flag ='Y';
1539:

Line 1552: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

1548: WHERE B.tax_id = p_tax_id ;
1549:
1550: CURSOR GL_DATE_CUR IS
1551: SELECT gl_date
1552: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
1553: WHERE CUSTOMER_TRX_LINE_ID = pr_old.customer_trx_line_id;
1554:
1555: CURSOR CREATED_FROM_CUR IS
1556: SELECT created_from