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_RECEIVABLE_APPLICATIONS

Line 103: FROM AR_RECEIVABLE_APPLICATIONS

99: AND REVERSAL_GL_DATE IS NULL;
100:
101: CURSOR rec_app_info (cr_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE) IS
102: SELECT *
103: FROM AR_RECEIVABLE_APPLICATIONS
104: WHERE CASH_RECEIPT_ID = cr_id
105: AND REVERSAL_GL_DATE IS NULL
106: ORDER BY decode(status,
107: 'APP' ,1,

Line 135: FROM AR_RECEIVABLE_APPLICATIONS

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'
138: AND APPLICATION_REF_TYPE = 'CLAIM'
139: AND NVL(TRANS_TO_RECEIPT_RATE,1) <> 1

Line 153: FROM ar_receivable_applications

149: WHERE receipt_method_id = p_receipt_method_id;
150:
151: CURSOR ar_rc_rec(p_cr_id number) is
152: SELECT *
153: FROM ar_receivable_applications
154: WHERE application_ref_id = p_cr_id
155: and application_ref_type = 'MISC_RECEIPT'
156: and display = 'Y';
157:

Line 169: ln_rec_application_id ar_receivable_applications.receivable_application_id%TYPE;

165: l_rm_code ar_receipt_methods.payment_type_code%TYPE;
166: l_credit_card boolean := FALSE;
167: l_rt_type ar_receivables_trx.type%TYPE;
168: l_cm_refund BOOLEAN := FALSE;
169: ln_rec_application_id ar_receivable_applications.receivable_application_id%TYPE;
170: ln_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
171: ln_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
172: l_bal_due_remaining number;
173:

Line 170: ln_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;

166: l_credit_card boolean := FALSE;
167: l_rt_type ar_receivables_trx.type%TYPE;
168: l_cm_refund BOOLEAN := FALSE;
169: ln_rec_application_id ar_receivable_applications.receivable_application_id%TYPE;
170: ln_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
171: ln_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
172: l_bal_due_remaining number;
173:
174: l_app_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */

Line 171: ln_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

167: l_rt_type ar_receivables_trx.type%TYPE;
168: l_cm_refund BOOLEAN := FALSE;
169: ln_rec_application_id ar_receivable_applications.receivable_application_id%TYPE;
170: ln_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
171: ln_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
172: l_bal_due_remaining number;
173:
174: l_app_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */
175:

Line 174: l_app_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */

170: ln_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
171: ln_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
172: l_bal_due_remaining number;
173:
174: l_app_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */
175:
176: /* end of modification in the declare section for CCR - pkt */
177:
178: new_adj NewAdjTyp;

Line 190: unapp_id AR_RECEIVABLE_APPLICATIONS.RECEIVABLE_APPLICATION_ID%TYPE;

186: acctd get_acctd_amounts%ROWTYPE;
187:
188: new_crh_id AR_CASH_RECEIPT_HISTORY.CASH_RECEIPT_HISTORY_ID%TYPE;
189: old_crh_id AR_CASH_RECEIPT_HISTORY.CASH_RECEIPT_HISTORY_ID%TYPE;
190: unapp_id AR_RECEIVABLE_APPLICATIONS.RECEIVABLE_APPLICATION_ID%TYPE;
191:
192: dis DIS_INFO%ROWTYPE;
193: acctd_curr_amount AR_CASH_RECEIPT_HISTORY.ACCTD_AMOUNT%TYPE;
194: acctd_dis_amount AR_DISTRIBUTIONS.ACCTD_AMOUNT_DR%TYPE;

Line 215: ins_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;

211:
212: total_unid NUMBER := 0; -- running total of 'UNID' records
213: cr_acctd_amount NUMBER;
214:
215: ins_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
216: upd_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
217: net_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
218:
219: -- Added for 11.5 VAT changes

Line 216: upd_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;

212: total_unid NUMBER := 0; -- running total of 'UNID' records
213: cr_acctd_amount NUMBER;
214:
215: ins_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
216: upd_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
217: net_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
218:
219: -- Added for 11.5 VAT changes
220: l_cr_rec ar_cash_receipts%ROWTYPE;

Line 217: net_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;

213: cr_acctd_amount NUMBER;
214:
215: ins_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
216: upd_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
217: net_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
218:
219: -- Added for 11.5 VAT changes
220: l_cr_rec ar_cash_receipts%ROWTYPE;
221: l_dist_rec ar_distributions%ROWTYPE;

Line 223: l_app_id ar_receivable_applications.receivable_application_id%TYPE;

219: -- Added for 11.5 VAT changes
220: l_cr_rec ar_cash_receipts%ROWTYPE;
221: l_dist_rec ar_distributions%ROWTYPE;
222: l_dummy ar_distributions.line_id%TYPE;
223: l_app_id ar_receivable_applications.receivable_application_id%TYPE;
224: l_ae_doc_rec ae_doc_rec_type;
225:
226: -- Added for iClaim API calls
227: l_bill_to_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE;

Line 1539: ar_receivable_applications ora,

1535: ,'' -- TAX_LINK_ID
1536: ,trx.invoice_currency_code -- TO_CURRENCY
1537: ,'' -- REF_MF_DIST_FLAG
1538: FROM ar_distributions ard,
1539: ar_receivable_applications ora,
1540: ra_customer_trx trx
1541: WHERE ora.receivable_application_id = old_rec_app.receivable_application_id
1542: AND ard.source_table = 'RA'
1543: AND ard.source_id = ora.receivable_application_id

Line 1980: ar_receivable_applications ora,

1976: ,'' -- TAX_LINK_ID
1977: ,trx.invoice_currency_code -- TO_CURRENCY
1978: ,'' -- REF_MF_DIST_FLAG
1979: FROM ar_distributions ard,
1980: ar_receivable_applications ora,
1981: ra_customer_trx trx
1982: WHERE ora.receivable_application_id = old_rec_app.receivable_application_id
1983: AND ard.source_table = 'RA'
1984: AND ard.source_id = ora.receivable_application_id