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 3712: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

3708: l_msg_count NUMBER;
3709: l_msg_data VARCHAR2(255);
3710: l_apply_err_count NUMBER;
3711:
3712: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
3713: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
3714: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
3715: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
3716: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

Line 3713: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

3709: l_msg_data VARCHAR2(255);
3710: l_apply_err_count NUMBER;
3711:
3712: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
3713: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
3714: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
3715: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
3716: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
3717:

Line 3714: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

3710: l_apply_err_count NUMBER;
3711:
3712: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
3713: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
3714: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
3715: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
3716: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
3717:
3718: l_procedure_name VARCHAR2(30);

Line 3715: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;

3711:
3712: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
3713: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
3714: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
3715: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
3716: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
3717:
3718: l_procedure_name VARCHAR2(30);
3719: l_debug_info VARCHAR2(200);

Line 3716: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

3712: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
3713: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
3714: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
3715: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
3716: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
3717:
3718: l_procedure_name VARCHAR2(30);
3719: l_debug_info VARCHAR2(200);
3720:

Line 5641: from ar_receivable_applications app

5637: IF (l_trx_class = 'PMT') THEN
5638:
5639: select -sum(app.amount_applied)
5640: into l_amount_due_remaining
5641: from ar_receivable_applications app
5642: where nvl( app.confirmed_flag, 'Y' ) = 'Y'
5643: and app.status = 'UNAPP'
5644: and app.cash_receipt_id = l_cash_receipt_id;
5645: ----------------------------------------------------------------------------------------

Line 6470: from ar_receivable_applications app

6466: l_amount_due_remaining NUMBER ;
6467:
6468: BEGIN
6469: select - sum(app.amount_applied) INTO l_amount_due_remaining
6470: from ar_receivable_applications app
6471: where nvl( app.confirmed_flag, 'Y' ) = 'Y'
6472: AND app.status = 'UNAPP'
6473: AND app.cash_receipt_id = p_cash_receipt_id;
6474: