eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_RATE_ADJ dependencies on AR_PAYMENT_SCHEDULES

Line 40: ar_payment_schedules ps,

36: rma.unidentified_ccid unidentified_ccid,
37: cr.tax_rate tax_rate,
38: cr.receivables_trx_id receivables_trx_id
39: FROM ar_cash_receipts cr,
40: ar_payment_schedules ps,
41: ar_receipt_method_accounts rma,
42: gl_sets_of_books sob
43: WHERE cr.cash_receipt_id = cr_id
44: AND ps.cash_receipt_id(+) = cr.cash_receipt_id

Line 115: (pay_id AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE) IS

111: 'UNID' ,5,
112: 'UNAPP' ,6); --This ordering is required for pairing UNAPP with APP, ACC or UNID rec record
113:
114: CURSOR ps_remaining_info
115: (pay_id AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE) IS
116: SELECT AMOUNT_DUE_REMAINING,
117: ACCTD_AMOUNT_DUE_REMAINING
118: FROM AR_PAYMENT_SCHEDULES
119: WHERE PAYMENT_SCHEDULE_ID = pay_id;

Line 118: FROM AR_PAYMENT_SCHEDULES

114: CURSOR ps_remaining_info
115: (pay_id AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE) IS
116: SELECT AMOUNT_DUE_REMAINING,
117: ACCTD_AMOUNT_DUE_REMAINING
118: FROM AR_PAYMENT_SCHEDULES
119: WHERE PAYMENT_SCHEDULE_ID = pay_id;
120:
121: CURSOR get_acctd_amounts
122: (cr_id AR_PAYMENT_SCHEDULES.CASH_RECEIPT_ID%TYPE) IS

Line 122: (cr_id AR_PAYMENT_SCHEDULES.CASH_RECEIPT_ID%TYPE) IS

118: FROM AR_PAYMENT_SCHEDULES
119: WHERE PAYMENT_SCHEDULE_ID = pay_id;
120:
121: CURSOR get_acctd_amounts
122: (cr_id AR_PAYMENT_SCHEDULES.CASH_RECEIPT_ID%TYPE) IS
123: SELECT ARCH.ACCTD_AMOUNT,
124: ARCH.ACCTD_FACTOR_DISCOUNT_AMOUNT,
125: ARPS.ACCTD_AMOUNT_DUE_REMAINING
126: FROM AR_PAYMENT_SCHEDULES ARPS,

Line 126: FROM AR_PAYMENT_SCHEDULES ARPS,

122: (cr_id AR_PAYMENT_SCHEDULES.CASH_RECEIPT_ID%TYPE) IS
123: SELECT ARCH.ACCTD_AMOUNT,
124: ARCH.ACCTD_FACTOR_DISCOUNT_AMOUNT,
125: ARPS.ACCTD_AMOUNT_DUE_REMAINING
126: FROM AR_PAYMENT_SCHEDULES ARPS,
127: AR_CASH_RECEIPT_HISTORY ARCH
128: WHERE ARPS.CASH_RECEIPT_ID = cr_id
129: AND ARCH.CASH_RECEIPT_ID = cr_id
130: AND ARCH.CURRENT_RECORD_FLAG = 'Y';

Line 133: (cr_id AR_PAYMENT_SCHEDULES.CASH_RECEIPT_ID%TYPE) IS

129: AND ARCH.CASH_RECEIPT_ID = cr_id
130: AND ARCH.CURRENT_RECORD_FLAG = 'Y';
131:
132: CURSOR apps_with_claims
133: (cr_id AR_PAYMENT_SCHEDULES.CASH_RECEIPT_ID%TYPE) IS
134: SELECT SECONDARY_APPLICATION_REF_ID
135: FROM AR_RECEIVABLE_APPLICATIONS
136: WHERE CASH_RECEIPT_ID = cr_id
137: AND STATUS = 'APP'

Line 205: app_acctd_amount AR_PAYMENT_SCHEDULES.ACCTD_AMOUNT_DUE_REMAINING%TYPE;

201: acctd_amt_due_remaining AR_MISC_CASH_DISTRIBUTIONS.ACCTD_AMOUNT%TYPE;
202: dist_acctd_amount AR_MISC_CASH_DISTRIBUTIONS.ACCTD_AMOUNT%TYPE;
203: new_acctd_amount AR_MISC_CASH_DISTRIBUTIONS.ACCTD_AMOUNT%TYPE;
204:
205: app_acctd_amount AR_PAYMENT_SCHEDULES.ACCTD_AMOUNT_DUE_REMAINING%TYPE;
206: new_ps_acctd_amount AR_PAYMENT_SCHEDULES.ACCTD_AMOUNT_DUE_REMAINING%TYPE;
207:
208: acctd_diff AR_CASH_RECEIPT_HISTORY.ACCTD_AMOUNT%TYPE;
209:

Line 206: new_ps_acctd_amount AR_PAYMENT_SCHEDULES.ACCTD_AMOUNT_DUE_REMAINING%TYPE;

202: dist_acctd_amount AR_MISC_CASH_DISTRIBUTIONS.ACCTD_AMOUNT%TYPE;
203: new_acctd_amount AR_MISC_CASH_DISTRIBUTIONS.ACCTD_AMOUNT%TYPE;
204:
205: app_acctd_amount AR_PAYMENT_SCHEDULES.ACCTD_AMOUNT_DUE_REMAINING%TYPE;
206: new_ps_acctd_amount AR_PAYMENT_SCHEDULES.ACCTD_AMOUNT_DUE_REMAINING%TYPE;
207:
208: acctd_diff AR_CASH_RECEIPT_HISTORY.ACCTD_AMOUNT%TYPE;
209:
210: temp_num NUMBER;

Line 247: l_inv_gl_date_closed ar_payment_schedules.gl_date_closed%TYPE;

243: l_new_net_rec_app_id NUMBER;
244: l_exchange_rate NUMBER;
245:
246: --Added for Bug No.3682777
247: l_inv_gl_date_closed ar_payment_schedules.gl_date_closed%TYPE;
248: l_inv_ps_status ar_payment_schedules.status%TYPE;
249:
250: --Added for Bug No.3713101
251: l_rct_gl_date_closed ar_payment_schedules.gl_date_closed%TYPE;

Line 248: l_inv_ps_status ar_payment_schedules.status%TYPE;

244: l_exchange_rate NUMBER;
245:
246: --Added for Bug No.3682777
247: l_inv_gl_date_closed ar_payment_schedules.gl_date_closed%TYPE;
248: l_inv_ps_status ar_payment_schedules.status%TYPE;
249:
250: --Added for Bug No.3713101
251: l_rct_gl_date_closed ar_payment_schedules.gl_date_closed%TYPE;
252: l_rct_ps_status ar_payment_schedules.status%TYPE;

Line 251: l_rct_gl_date_closed ar_payment_schedules.gl_date_closed%TYPE;

247: l_inv_gl_date_closed ar_payment_schedules.gl_date_closed%TYPE;
248: l_inv_ps_status ar_payment_schedules.status%TYPE;
249:
250: --Added for Bug No.3713101
251: l_rct_gl_date_closed ar_payment_schedules.gl_date_closed%TYPE;
252: l_rct_ps_status ar_payment_schedules.status%TYPE;
253: claim_cancel_api_error EXCEPTION;
254: claim_create_api_error EXCEPTION;
255:

Line 252: l_rct_ps_status ar_payment_schedules.status%TYPE;

248: l_inv_ps_status ar_payment_schedules.status%TYPE;
249:
250: --Added for Bug No.3713101
251: l_rct_gl_date_closed ar_payment_schedules.gl_date_closed%TYPE;
252: l_rct_ps_status ar_payment_schedules.status%TYPE;
253: claim_cancel_api_error EXCEPTION;
254: claim_create_api_error EXCEPTION;
255:
256: --Bug#2750340

Line 1620: UPDATE ar_payment_schedules

1616: --Since in this case we are not re-creating the write-off record
1617: --we should not update the amounts in PS only status needs to be
1618: --opened.
1619:
1620: UPDATE ar_payment_schedules
1621: SET status = 'OP',
1622: gl_date_closed = ARP_GLOBAL.G_MAX_DATE,
1623: actual_date_closed = ARP_GLOBAL.G_MAX_DATE
1624: WHERE payment_schedule_id = cr.payment_schedule_id;

Line 1709: FROM ar_payment_schedules

1705: recalculated as this receipt becomes the 'main' receipt. */
1706: IF old_rec_app.receivables_trx_id = -16 THEN
1707: SELECT exchange_rate
1708: INTO l_exchange_rate
1709: FROM ar_payment_schedules
1710: WHERE payment_schedule_id = old_rec_app.applied_payment_schedule_id;
1711: ins_ra_rec.acctd_amount_applied_to :=
1712: ARPCURR.functional_amount(
1713: amount => old_rec_app.amount_applied

Line 1802: FROM ar_payment_schedules

1798: the current gl_date closed is less than gl_date of the reate adjustment */
1799:
1800: SELECT gl_date_closed,status
1801: INTO l_inv_gl_date_closed,l_inv_ps_status
1802: FROM ar_payment_schedules
1803: WHERE payment_schedule_id=ins_ra_rec.applied_payment_schedule_id;
1804:
1805: IF ((l_inv_gl_date_closed 1806: AND l_inv_ps_status='CL')

Line 1808: UPDATE ar_payment_schedules

1804:
1805: IF ((l_inv_gl_date_closed 1806: AND l_inv_ps_status='CL')
1807: THEN
1808: UPDATE ar_payment_schedules
1809: SET gl_date_closed=ins_ra_rec.gl_date
1810: WHERE payment_schedule_id=ins_ra_rec.applied_payment_schedule_id;
1811: END IF;
1812:

Line 2313: FROM ar_payment_schedules

2309: the current gl_date closed is less than gl_date of the rate adjustment */
2310:
2311: SELECT gl_date_closed,status
2312: INTO l_rct_gl_date_closed,l_rct_ps_status
2313: FROM ar_payment_schedules
2314: WHERE payment_schedule_id= cr.payment_schedule_id;
2315: IF ((l_rct_gl_date_closed < nvl(new_crh.gl_date,l_rct_gl_date_closed))
2316: AND l_rct_ps_status='CL') THEN
2317: UPDATE ar_payment_schedules

Line 2317: UPDATE ar_payment_schedules

2313: FROM ar_payment_schedules
2314: WHERE payment_schedule_id= cr.payment_schedule_id;
2315: IF ((l_rct_gl_date_closed < nvl(new_crh.gl_date,l_rct_gl_date_closed))
2316: AND l_rct_ps_status='CL') THEN
2317: UPDATE ar_payment_schedules
2318: SET gl_date_closed = new_crh.gl_date
2319: WHERE payment_schedule_id = cr.payment_schedule_id;
2320: END IF;
2321: END IF;