APPS.FV_SF1081_TRANSACTION dependencies on CE_BANK_ACCOUNTS

Line 370: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;

366: vc_trx_number ra_customer_trx.trx_number%TYPE;
367: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
368: vc_customer_name hz_parties.party_name%TYPE;
369: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
370: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;
371: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;
372: vc_address1 hz_locations.address1%TYPE;
373: vc_address2 hz_locations.address2%TYPE;
374: vc_address3 hz_locations.address3%TYPE;

Line 507: ce_bank_accounts cba,

503: hz_parties hzp,
504: ra_customer_trx rct,
505: ra_customer_trx_lines rtl,
506: ra_cust_trx_line_gl_dist rld,
507: ce_bank_accounts cba,
508: ce_bank_acct_uses_all cbau
509: WHERE
510: hzp.party_id = hzca.party_id
511: AND hzca.cust_account_id = hzcas.cust_account_id

Line 723: ce_bank_accounts cba,

719: BEGIN
720: select cba.agency_location_code
721: into v_alc_code
722: from ar_receipt_method_accounts arma,
723: ce_bank_accounts cba,
724: ce_bank_acct_uses_all cbau
725: where arma.primary_flag = 'Y'
726: and arma.receipt_method_id = vc_receipt_method_id
727: and cbau.bank_acct_use_id = arma.remit_bank_acct_use_id