DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_AR_TRX_INS_LINES_T

Line 1281: || Check whether the JAI_AR_TRX_INS_LINES_T table still has the row corresponding to the current

1277:
1278: -- Start of bug 4185033
1279: /*
1280: || Cursor added by aiyer for the bug 4185033
1281: || Check whether the JAI_AR_TRX_INS_LINES_T table still has the row corresponding to the current
1282: || customer_trx_id
1283: */
1284: CURSOR cur_chk_temp_lines_exist( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE ) /* changed the RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE to JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE for the bug 5364288 */
1285: IS

Line 1290: JAI_AR_TRX_INS_LINES_T

1286: /* commented and added the below for bug#11664009 and added the below
1287: SELECT
1288: 1
1289: FROM
1290: JAI_AR_TRX_INS_LINES_T
1291: WHERE
1292: customer_trx_id = cp_customer_trx_id ;
1293: */
1294: SELECT '1'

Line 3220: INSERT INTO JAI_AR_TRX_INS_LINES_T ( paddr,

3216: TAX_TYPE_REC.tax_amt := 0;
3217: END IF;
3218:
3219:
3220: INSERT INTO JAI_AR_TRX_INS_LINES_T ( paddr,
3221: extended_amount,
3222: customer_trx_line_id,
3223: customer_trx_id,
3224: set_of_books_id,