DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on RA_CUST_RECEIPT_METHODS

Line 532: ra_cust_receipt_methods rcrm,

528: CURSOR cust_payment_method_info_cur(p_siteuseid NUMBER, p_currcode VARCHAR2) IS
529: SELECT arm.receipt_method_id receipt_method_id, arm.payment_channel_code payment_channel_code,
530: arc.creation_status receipt_creation_status
531: FROM ar_receipt_methods arm,
532: ra_cust_receipt_methods rcrm,
533: ar_receipt_method_accounts arma,
534: ce_bank_acct_uses_ou_v aba,
535: ce_bank_accounts cba,
536: ar_receipt_classes arc

Line 679: l_customer_id RA_CUST_RECEIPT_METHODS.CUSTOMER_ID%TYPE;

675: cust_payment_method_info cust_payment_method_info_cur%ROWTYPE;
676: cc_profile_pmt_method_info cc_profile_pmt_method_info_cur%ROWTYPE;
677: ba_profile_pmt_method_info ba_profile_pmt_method_info_cur%ROWTYPE;
678:
679: l_customer_id RA_CUST_RECEIPT_METHODS.CUSTOMER_ID%TYPE;
680: l_site_use_id RA_CUST_RECEIPT_METHODS.SITE_USE_ID%TYPE;
681: l_currency_code AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE%TYPE;
682:
683: l_procedure_name VARCHAR2(30);

Line 680: l_site_use_id RA_CUST_RECEIPT_METHODS.SITE_USE_ID%TYPE;

676: cc_profile_pmt_method_info cc_profile_pmt_method_info_cur%ROWTYPE;
677: ba_profile_pmt_method_info ba_profile_pmt_method_info_cur%ROWTYPE;
678:
679: l_customer_id RA_CUST_RECEIPT_METHODS.CUSTOMER_ID%TYPE;
680: l_site_use_id RA_CUST_RECEIPT_METHODS.SITE_USE_ID%TYPE;
681: l_currency_code AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE%TYPE;
682:
683: l_procedure_name VARCHAR2(30);
684: l_debug_info VARCHAR2(200);

Line 5974: ra_cust_receipt_methods rcrm,

5970:
5971: SELECT count ( arm.receipt_method_id )
5972: INTO customer_cc_payment_method
5973: FROM ar_receipt_methods arm,
5974: ra_cust_receipt_methods rcrm,
5975: ar_receipt_method_accounts arma,
5976: ce_bank_acct_uses_ou_v aba,
5977: ce_bank_accounts cba,
5978: ar_receipt_classes arc

Line 6151: ra_cust_receipt_methods rcrm,

6147:
6148: SELECT count ( arm.receipt_method_id )
6149: INTO customer_bank_payment_method
6150: FROM ar_receipt_methods arm,
6151: ra_cust_receipt_methods rcrm,
6152: ar_receipt_method_accounts arma,
6153: ce_bank_acct_uses_ou_v aba,
6154: ce_bank_accounts cba,
6155: ar_receipt_classes arc