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 1679: UPDATE ar_payment_schedules

1675: --Since in this case we are not re-creating the write-off record
1676: --we should not update the amounts in PS only status needs to be
1677: --opened.
1678:
1679: UPDATE ar_payment_schedules
1680: SET status = 'OP',
1681: gl_date_closed = ARP_GLOBAL.G_MAX_DATE,
1682: actual_date_closed = ARP_GLOBAL.G_MAX_DATE
1683: WHERE payment_schedule_id = cr.payment_schedule_id;

Line 1780: FROM ar_payment_schedules

1776: recalculated as this receipt becomes the 'main' receipt. */
1777: IF old_rec_app.receivables_trx_id = -16 THEN
1778: SELECT exchange_rate
1779: INTO l_exchange_rate
1780: FROM ar_payment_schedules
1781: WHERE payment_schedule_id = old_rec_app.applied_payment_schedule_id;
1782: ins_ra_rec.acctd_amount_applied_to :=
1783: ARPCURR.functional_amount(
1784: amount => old_rec_app.amount_applied

Line 1873: FROM ar_payment_schedules

1869: the current gl_date closed is less than gl_date of the reate adjustment */
1870:
1871: SELECT gl_date_closed,status
1872: INTO l_inv_gl_date_closed,l_inv_ps_status
1873: FROM ar_payment_schedules
1874: WHERE payment_schedule_id=ins_ra_rec.applied_payment_schedule_id;
1875:
1876: IF ((l_inv_gl_date_closed 1877: AND l_inv_ps_status='CL')

Line 1879: UPDATE ar_payment_schedules

1875:
1876: IF ((l_inv_gl_date_closed 1877: AND l_inv_ps_status='CL')
1878: THEN
1879: UPDATE ar_payment_schedules
1880: SET gl_date_closed=ins_ra_rec.gl_date
1881: WHERE payment_schedule_id=ins_ra_rec.applied_payment_schedule_id;
1882: END IF;
1883:

Line 2393: FROM ar_payment_schedules

2389: the current gl_date closed is less than gl_date of the rate adjustment */
2390:
2391: SELECT gl_date_closed,status
2392: INTO l_rct_gl_date_closed,l_rct_ps_status
2393: FROM ar_payment_schedules
2394: WHERE payment_schedule_id= cr.payment_schedule_id;
2395: IF ((l_rct_gl_date_closed < nvl(new_crh.gl_date,l_rct_gl_date_closed))
2396: AND l_rct_ps_status='CL') THEN
2397: UPDATE ar_payment_schedules

Line 2397: UPDATE ar_payment_schedules

2393: FROM ar_payment_schedules
2394: WHERE payment_schedule_id= cr.payment_schedule_id;
2395: IF ((l_rct_gl_date_closed < nvl(new_crh.gl_date,l_rct_gl_date_closed))
2396: AND l_rct_ps_status='CL') THEN
2397: UPDATE ar_payment_schedules
2398: SET gl_date_closed = new_crh.gl_date
2399: WHERE payment_schedule_id = cr.payment_schedule_id;
2400: END IF;
2401: END IF;