DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on RA_CUST_RECEIPT_METHODS

Line 525: ra_cust_receipt_methods rcrm,

521: CURSOR cust_payment_method_info_cur(p_siteuseid NUMBER, p_currcode VARCHAR2) IS
522: SELECT arm.receipt_method_id receipt_method_id, arm.payment_channel_code payment_channel_code,
523: arc.creation_status receipt_creation_status
524: FROM ar_receipt_methods arm,
525: ra_cust_receipt_methods rcrm,
526: ar_receipt_method_accounts arma,
527: ce_bank_acct_uses_ou_v aba,
528: ce_bank_accounts cba,
529: ar_receipt_classes arc

Line 670: l_customer_id RA_CUST_RECEIPT_METHODS.CUSTOMER_ID%TYPE;

666: cust_payment_method_info cust_payment_method_info_cur%ROWTYPE;
667: cc_profile_pmt_method_info cc_profile_pmt_method_info_cur%ROWTYPE;
668: ba_profile_pmt_method_info ba_profile_pmt_method_info_cur%ROWTYPE;
669:
670: l_customer_id RA_CUST_RECEIPT_METHODS.CUSTOMER_ID%TYPE;
671: l_site_use_id RA_CUST_RECEIPT_METHODS.SITE_USE_ID%TYPE;
672: l_currency_code AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE%TYPE;
673:
674: l_procedure_name VARCHAR2(30);

Line 671: l_site_use_id RA_CUST_RECEIPT_METHODS.SITE_USE_ID%TYPE;

667: cc_profile_pmt_method_info cc_profile_pmt_method_info_cur%ROWTYPE;
668: ba_profile_pmt_method_info ba_profile_pmt_method_info_cur%ROWTYPE;
669:
670: l_customer_id RA_CUST_RECEIPT_METHODS.CUSTOMER_ID%TYPE;
671: l_site_use_id RA_CUST_RECEIPT_METHODS.SITE_USE_ID%TYPE;
672: l_currency_code AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE%TYPE;
673:
674: l_procedure_name VARCHAR2(30);
675: l_debug_info VARCHAR2(200);

Line 5328: ra_cust_receipt_methods rcrm,

5324:
5325: SELECT count ( arm.receipt_method_id )
5326: INTO customer_cc_payment_method
5327: FROM ar_receipt_methods arm,
5328: ra_cust_receipt_methods rcrm,
5329: ar_receipt_method_accounts arma,
5330: ce_bank_acct_uses_ou_v aba,
5331: ce_bank_accounts cba,
5332: ar_receipt_classes arc

Line 5504: ra_cust_receipt_methods rcrm,

5500:
5501: SELECT count ( arm.receipt_method_id )
5502: INTO customer_bank_payment_method
5503: FROM ar_receipt_methods arm,
5504: ra_cust_receipt_methods rcrm,
5505: ar_receipt_method_accounts arma,
5506: ce_bank_acct_uses_ou_v aba,
5507: ce_bank_accounts cba,
5508: ar_receipt_classes arc