APPS.JAI_AR_TAX_PROCESSING_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 33: t_ra_customer_trx_lines_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;

29: lv_debug_info VARCHAR2(4000);
30: lb_jai_exists BOOLEAN;
31: lv_action VARCHAR2(20);
32: t_ra_customer_trx_rec RA_CUSTOMER_TRX_ALL%ROWTYPE;
33: t_ra_customer_trx_lines_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;
34: t_jai_ar_trx_rec JAI_AR_TRXS%ROWTYPE;
35: t_jai_ar_trx_lines_rec JAI_AR_TRX_LINES%ROWTYPE;
36: lv_return_message VARCHAR2(2000);
37: lv_return_code VARCHAR2(100);

Line 48: FROM RA_CUSTOMER_TRX_LINES_ALL

44: WHERE CUSTOMER_TRX_ID = p_customer_trx_id;
45:
46: CURSOR c_ra_customer_trx_lines(p_customer_trx_line_id NUMBER) IS
47: SELECT *
48: FROM RA_CUSTOMER_TRX_LINES_ALL
49: WHERE CUSTOMER_TRX_LINE_ID = p_customer_trx_line_id;
50:
51: CURSOR c_jai_ar_trx(p_customer_trx_id NUMBER) IS
52: SELECT * FROM JAI_AR_TRXS WHERE CUSTOMER_TRX_ID = p_customer_trx_id;

Line 118: FROM RA_CUSTOMER_TRX_LINES_ALL rctla

114: RAISE le_error;
115: END IF;
116:
117: FOR c_ra_customer_line IN (SELECT customer_trx_line_id
118: FROM RA_CUSTOMER_TRX_LINES_ALL rctla
119: WHERE rctla.customer_trx_id =
120: p_transaction_rec.trx_id
121: AND rctla.line_type = 'LINE') LOOP
122:

Line 337: FROM RA_CUSTOMER_TRX_LINES_ALL rctla

333: RAISE le_error;
334: END IF;
335:
336: FOR c_ra_customer_line IN (SELECT customer_trx_line_id
337: FROM RA_CUSTOMER_TRX_LINES_ALL rctla
338: WHERE rctla.customer_trx_id =
339: p_event_class_rec.trx_id
340: AND rctla.line_type = 'LINE') LOOP
341: OPEN c_ra_customer_trx_lines(c_ra_customer_line.customer_trx_line_id);

Line 416: FROM RA_CUSTOMER_TRX_LINES_ALL rctla

412:
413: END IF;
414:
415: FOR c_ra_customer_line IN (SELECT customer_trx_line_id
416: FROM RA_CUSTOMER_TRX_LINES_ALL rctla
417: WHERE rctla.customer_trx_id =
418: p_event_class_rec.trx_id
419: AND rctla.line_type = 'LINE') LOOP
420: OPEN c_ra_customer_trx_lines(c_ra_customer_line.customer_trx_line_id);

Line 522: FROM RA_CUSTOMER_TRX_LINES_ALL rctla

518: FOR c_ra_customer_line IN (SELECT customer_trx_line_id
519: FROM JAI_AR_TRX_LINES
520: WHERE customer_trx_line_id NOT IN
521: (SELECT customer_trx_line_id
522: FROM RA_CUSTOMER_TRX_LINES_ALL rctla
523: WHERE rctla.customer_trx_id =
524: p_event_class_rec.trx_id
525: AND rctla.line_type = 'LINE')
526: AND customer_trx_id =