APPS.ARP_ETAX_UTIL dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1503: l_app_rec ar_receivable_applications%ROWTYPE;

1499: l_msg VARCHAR2(2000);
1500: l_mode VARCHAR2(20);
1501: l_adj_rec ar_adjustments%ROWTYPE;
1502: l_trx_rec ra_customer_trx%ROWTYPE;
1503: l_app_rec ar_receivable_applications%ROWTYPE;
1504: l_rows_inserted NUMBER;
1505: l_acct_meth ar_system_parameters.accounting_method%TYPE;
1506: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
1507: l_gt_passed BOOLEAN := FALSE;

Line 1799: l_app_rec ar_receivable_applications%ROWTYPE;

1795: l_msg_count NUMBER;
1796: l_msg_data VARCHAR2(4000);
1797: l_msg VARCHAR2(2000);
1798: l_trx_rec ra_customer_trx%ROWTYPE;
1799: l_app_rec ar_receivable_applications%ROWTYPE;
1800: l_acct_meth ar_system_parameters.accounting_method%TYPE;
1801: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
1802:
1803: BEGIN

Line 1811: FROM ar_receivable_applications

1807: END IF;
1808:
1809: SELECT *
1810: INTO l_app_rec
1811: FROM ar_receivable_applications
1812: WHERE receivable_application_id = p_rec_app_id;
1813:
1814: SELECT *
1815: INTO l_trx_rec

Line 2331: SELECT ar_receivable_applications_s.nextval

2327: It may be zero coming from arcpau */
2328: IF NVL(p_ra_app_id,0) = 0
2329: THEN
2330: /* get it from sequence */
2331: SELECT ar_receivable_applications_s.nextval
2332: INTO p_ra_app_id
2333: FROM DUAL;
2334:
2335: IF PG_DEBUG IN ('Y','C')