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 HZ_CUST_PROFILE_AMTS

Line 1211: p_cust_min_amt OUT NOCOPY hz_cust_profile_amts.auto_rec_min_receipt_amount%TYPE,

1207: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,
1208: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,
1209: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
1210: p_cust_bank_account_id OUT NOCOPY ra_customer_trx.customer_bank_account_id%TYPE,
1211: p_cust_min_amt OUT NOCOPY hz_cust_profile_amts.auto_rec_min_receipt_amount%TYPE,
1212: p_payment_trxn_extension_id OUT NOCOPY ra_customer_trx.payment_trxn_extension_id%TYPE,
1213: p_payment_channel_code OUT NOCOPY ar_receipt_methods.payment_channel_code%TYPE,
1214: p_instrument_type OUT NOCOPY IBY_PMT_INSTR_USES_ALL.instrument_type%TYPE,
1215: p_return_status OUT NOCOPY VARCHAR2

Line 1299: hz_cust_profile_amts cust_cpa,

1295: p.payment_channel_code,
1296: u.instrument_id
1297: FROM hz_customer_profiles cust_cp,
1298: hz_customer_profiles site_cp,
1299: hz_cust_profile_amts cust_cpa,
1300: hz_cust_profile_amts site_cpa,
1301: ra_customer_trx ct,
1302: iby_fndcpt_tx_extensions x,
1303: iby_pmt_instr_uses_all u,

Line 1300: hz_cust_profile_amts site_cpa,

1296: u.instrument_id
1297: FROM hz_customer_profiles cust_cp,
1298: hz_customer_profiles site_cp,
1299: hz_cust_profile_amts cust_cpa,
1300: hz_cust_profile_amts site_cpa,
1301: ra_customer_trx ct,
1302: iby_fndcpt_tx_extensions x,
1303: iby_pmt_instr_uses_all u,
1304: iby_fndcpt_pmt_chnnls_b p,

Line 1992: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R2.pay_cust_id

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:
1996: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN

Line 2281: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R1.pay_cust_id

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:
2285: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN

Line 2569: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R3.pay_cust_id

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:
2573: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN

Line 2856: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R4.pay_cust_id

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:
2860: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN

Line 3146: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R5.pay_cust_id

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:
3150: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN

Line 3431: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R6.pay_cust_id

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:
3435: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN

Line 3696: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R7.pay_cust_id

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:
3700: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN

Line 3962: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R8.pay_cust_id

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:
3966: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN