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.AR_IREC_PAYMENTS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 3243: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

3239: l_msg_count NUMBER;
3240: l_msg_data VARCHAR2(255);
3241: l_apply_err_count NUMBER;
3242:
3243: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
3244: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
3245: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
3246: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
3247: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

Line 3244: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

3240: l_msg_data VARCHAR2(255);
3241: l_apply_err_count NUMBER;
3242:
3243: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
3244: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
3245: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
3246: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
3247: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
3248:

Line 3245: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

3241: l_apply_err_count NUMBER;
3242:
3243: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
3244: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
3245: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
3246: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
3247: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
3248:
3249: l_procedure_name VARCHAR2(30);

Line 3246: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;

3242:
3243: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
3244: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
3245: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
3246: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
3247: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
3248:
3249: l_procedure_name VARCHAR2(30);
3250: l_debug_info VARCHAR2(200);

Line 3247: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

3243: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
3244: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
3245: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
3246: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
3247: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
3248:
3249: l_procedure_name VARCHAR2(30);
3250: l_debug_info VARCHAR2(200);
3251:

Line 4996: from ar_receivable_applications app

4992: IF (l_trx_class = 'PMT') THEN
4993:
4994: select -sum(app.amount_applied)
4995: into l_amount_due_remaining
4996: from ar_receivable_applications app
4997: where nvl( app.confirmed_flag, 'Y' ) = 'Y'
4998: and app.status = 'UNAPP'
4999: and app.cash_receipt_id = l_cash_receipt_id;
5000: ----------------------------------------------------------------------------------------

Line 5822: from ar_receivable_applications app

5818: l_amount_due_remaining NUMBER ;
5819:
5820: BEGIN
5821: select - sum(app.amount_applied) INTO l_amount_due_remaining
5822: from ar_receivable_applications app
5823: where nvl( app.confirmed_flag, 'Y' ) = 'Y'
5824: AND app.status = 'UNAPP'
5825: AND app.cash_receipt_id = p_cash_receipt_id;
5826: