[Home] [Help]
1390: p_ae_sys_rec.base_min_acc_unit,
1391: p_ae_sys_rec.gain_cc_id,
1392: p_ae_sys_rec.loss_cc_id,
1393: p_ae_sys_rec.round_cc_id
1394: FROM ar_system_parameters sysp,
1395: gl_sets_of_books sob,
1396: fnd_currencies c
1397: WHERE sob.set_of_books_id = sysp.set_of_books_id
1398: AND sob.currency_code = c.currency_code;
1437: l_adj_rec ar_adjustments%ROWTYPE;
1438: l_trx_rec ra_customer_trx%ROWTYPE;
1439: l_app_rec ar_receivable_applications%ROWTYPE;
1440: l_rows_inserted NUMBER;
1441: l_acct_meth ar_system_parameters.accounting_method%TYPE;
1442: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
1443: l_gt_passed BOOLEAN := FALSE;
1444:
1445: -- Added for Line Level Adjustment
1732: l_msg_data VARCHAR2(4000);
1733: l_msg VARCHAR2(2000);
1734: l_trx_rec ra_customer_trx%ROWTYPE;
1735: l_app_rec ar_receivable_applications%ROWTYPE;
1736: l_acct_meth ar_system_parameters.accounting_method%TYPE;
1737: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
1738:
1739: BEGIN
1740: IF PG_DEBUG in ('Y', 'C') THEN
2113: FROM
2114: RA_CUSTOMER_TRX TRX,
2115: RA_CUST_TRX_TYPES TT,
2116: RA_CUSTOMER_TRX_LINES LINES,
2117: AR_SYSTEM_PARAMETERS AR,
2118: FND_CURRENCIES CUR,
2119: HZ_CUST_ACCOUNTS BILL_CUST,
2120: HZ_PARTIES BILL_PARTY,
2121: HZ_CUST_ACCT_SITES BILL_AS,
3017: l_base_precision,
3018: l_base_mau
3019: FROM gl_sets_of_books sob,
3020: fnd_currencies c,
3021: ar_system_parameters sp
3022: WHERE sob.set_of_books_id = sp.set_of_books_id
3023: AND sob.currency_code = c.currency_code;
3024:
3025: