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_AUTOREC_API dependencies on DUAL

Line 1991: from dual

1987: fnd_file.put_line(fnd_file.log,'l_err_code :'||l_err_code);
1988: fnd_file.put_line(fnd_file.log,'Amount :'||R2.amt);
1989: select 'ARZCAR_CUST_MIN_AMT'
1990: INTO l_err_code
1991: from dual
1992: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R2.pay_cust_id
1993: AND auto_rec_min_receipt_amount > R2.amt
1994: AND currency_code = p_currency_code); -- Currency_Code Condition Added for Bug:5488085
1995:

Line 2280: from dual

2276:
2277: BEGIN
2278: select 'ARZCAR_CUST_MIN_AMT'
2279: INTO l_err_code
2280: from dual
2281: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R1.pay_cust_id
2282: AND auto_rec_min_receipt_amount > R1.amt
2283: AND currency_code = p_currency_code); -- For Bug:5488085
2284:

Line 2568: from dual

2564: BEGIN
2565:
2566: select 'ARZCAR_CUST_MIN_AMT'
2567: INTO l_err_code
2568: from dual
2569: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R3.pay_cust_id
2570: AND auto_rec_min_receipt_amount > R3.amt
2571: AND currency_code = p_currency_code); --For Bug:5488085
2572:

Line 2855: from dual

2851:
2852: BEGIN
2853: select 'ARZCAR_CUST_MIN_AMT'
2854: INTO l_err_code
2855: from dual
2856: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R4.pay_cust_id
2857: AND auto_rec_min_receipt_amount > R4.amt
2858: AND currency_code = p_currency_code);--For Bug:5488085
2859:

Line 3145: from dual

3141: /* validate the cust bank min amount */
3142: BEGIN
3143: select 'ARZCAR_CUST_MIN_AMT'
3144: INTO l_err_code
3145: from dual
3146: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R5.pay_cust_id
3147: AND auto_rec_min_receipt_amount > R5.amt
3148: AND currency_code = p_currency_code); --For Bug:5488085
3149:

Line 3430: from dual

3426:
3427: BEGIN
3428: select 'ARZCAR_CUST_MIN_AMT'
3429: INTO l_err_code
3430: from dual
3431: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R6.pay_cust_id
3432: AND auto_rec_min_receipt_amount > R6.amt
3433: AND currency_code = p_currency_code);--For Bug:5488085
3434:

Line 3695: from dual

3691: /* validate the cust bank min amount */
3692: BEGIN
3693: select 'ARZCAR_CUST_MIN_AMT'
3694: INTO l_err_code
3695: from dual
3696: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R7.pay_cust_id
3697: AND auto_rec_min_receipt_amount > R7.amt
3698: AND currency_code = p_currency_code); --For Bug:5488085
3699:

Line 3961: from dual

3957:
3958: BEGIN
3959: select 'ARZCAR_CUST_MIN_AMT'
3960: INTO l_err_code
3961: from dual
3962: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R8.pay_cust_id
3963: AND auto_rec_min_receipt_amount > R8.amt
3964: AND currency_code = p_currency_code); --For Bug:5488085
3965:

Line 4251: sysdate FROM DUAL;

4247: l_created_by,
4248: l_last_update_login,
4249: l_program_application_id,
4250: l_program_id,
4251: sysdate FROM DUAL;
4252:
4253: IF PG_DEBUG in ('Y','C') THEN
4254: arp_standard.debug ( 'the rows in exceptions = ' || SQL%ROWCOUNT );
4255: END IF;