APPS.ARP_RATE_ADJ dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 95: CURSOR misc_info (cr_id AR_MISC_CASH_DISTRIBUTIONS.CASH_RECEIPT_ID%TYPE) IS

91: HAVING SUM(nvl(d.acctd_amount_dr,0) - nvl(d.acctd_amount_cr,0)) <> 0
92: OR (SUM(nvl(d.acctd_amount_dr,0) - nvl(d.acctd_amount_cr,0)) = 0
93: AND SUM(nvl(d.amount_dr,0) - nvl(d.amount_cr,0)) <> 0 ) ;
94:
95: CURSOR misc_info (cr_id AR_MISC_CASH_DISTRIBUTIONS.CASH_RECEIPT_ID%TYPE) IS
96: SELECT *
97: FROM AR_MISC_CASH_DISTRIBUTIONS
98: WHERE CASH_RECEIPT_ID = cr_id
99: AND REVERSAL_GL_DATE IS NULL;

Line 97: FROM AR_MISC_CASH_DISTRIBUTIONS

93: AND SUM(nvl(d.amount_dr,0) - nvl(d.amount_cr,0)) <> 0 ) ;
94:
95: CURSOR misc_info (cr_id AR_MISC_CASH_DISTRIBUTIONS.CASH_RECEIPT_ID%TYPE) IS
96: SELECT *
97: FROM AR_MISC_CASH_DISTRIBUTIONS
98: WHERE CASH_RECEIPT_ID = cr_id
99: AND REVERSAL_GL_DATE IS NULL;
100:
101: CURSOR rec_app_info (cr_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE) IS

Line 200: amt_due_remaining AR_MISC_CASH_DISTRIBUTIONS.AMOUNT%TYPE;

196: amount_dr NUMBER;
197: acctd_amount_cr NUMBER;
198: acctd_amount_dr NUMBER;
199:
200: amt_due_remaining AR_MISC_CASH_DISTRIBUTIONS.AMOUNT%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:

Line 201: acctd_amt_due_remaining AR_MISC_CASH_DISTRIBUTIONS.ACCTD_AMOUNT%TYPE;

197: acctd_amount_cr NUMBER;
198: acctd_amount_dr NUMBER;
199:
200: amt_due_remaining AR_MISC_CASH_DISTRIBUTIONS.AMOUNT%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;

Line 202: dist_acctd_amount AR_MISC_CASH_DISTRIBUTIONS.ACCTD_AMOUNT%TYPE;

198: acctd_amount_dr NUMBER;
199:
200: amt_due_remaining AR_MISC_CASH_DISTRIBUTIONS.AMOUNT%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;

Line 203: new_acctd_amount AR_MISC_CASH_DISTRIBUTIONS.ACCTD_AMOUNT%TYPE;

199:
200: amt_due_remaining AR_MISC_CASH_DISTRIBUTIONS.AMOUNT%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: