APPS.JAI_TAX_PROCESSING_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 884: t_ra_customer_trx_lines_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;

880: is
881: lb_jai_exists BOOLEAN;
882: lv_action VARCHAR2(20);
883: t_ra_customer_trx_rec RA_CUSTOMER_TRX_ALL%ROWTYPE;
884: t_ra_customer_trx_lines_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;
885: lv_return_message VARCHAR2(2000);
886: lv_return_code VARCHAR2(100);
887: ln_trx_line_id NUMBER;
888: le_error EXCEPTION;

Line 900: FROM RA_CUSTOMER_TRX_LINES_ALL

896:
897: CURSOR c_ra_customer_trx_lines(p_customer_trx_line_id NUMBER)
898: IS
899: SELECT *
900: FROM RA_CUSTOMER_TRX_LINES_ALL
901: WHERE CUSTOMER_TRX_LINE_ID = p_customer_trx_line_id;
902:
903:
904: CURSOR c_jai_ar_trx_lines(p_customer_trx_line_id NUMBER)

Line 913: FROM RA_CUSTOMER_TRX_LINES_ALL

909:
910: CURSOR c_ra_cust_trx_lines(p_customer_trx_id NUMBER)
911: IS
912: SELECT customer_trx_line_id
913: FROM RA_CUSTOMER_TRX_LINES_ALL
914: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
915: AND LINE_TYPE = 'LINE';
916:
917:

Line 1130: t_ra_customer_trx_lines_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;

1126: lb_jai_exists BOOLEAN;
1127: lv_action VARCHAR2(20);
1128: t_jai_ar_trx_rec JAI_AR_TRXS%ROWTYPE;
1129: t_ra_customer_trx_rec RA_CUSTOMER_TRX_ALL%ROWTYPE;
1130: t_ra_customer_trx_lines_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;
1131: lv_return_message VARCHAR2(2000);
1132: lv_return_code VARCHAR2(100);
1133: ln_trx_line_id NUMBER;
1134: le_error EXCEPTION;

Line 1153: FROM RA_CUSTOMER_TRX_LINES_ALL

1149:
1150: CURSOR c_ra_customer_trx_lines(p_customer_trx_line_id NUMBER)
1151: IS
1152: SELECT *
1153: FROM RA_CUSTOMER_TRX_LINES_ALL
1154: WHERE CUSTOMER_TRX_LINE_ID = p_customer_trx_line_id;
1155:
1156: lv_remark1 varchar2(10);
1157: lv_remark2 varchar2(10);