APPS.FV_SF1081_TRANSACTION dependencies on CE_BANK_ACCOUNTS

Line 412: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;

408: vc_trx_number ra_customer_trx.trx_number%TYPE;
409: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
410: vc_customer_name hz_parties.party_name%TYPE;
411: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
412: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;
413: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;
414: vc_address1 hz_locations.address1%TYPE;
415: vc_address2 hz_locations.address2%TYPE;
416: vc_address3 hz_locations.address3%TYPE;

Line 557: ce_bank_accounts cba,

553: hz_parties hzp,
554: ra_customer_trx rct,
555: ra_customer_trx_lines rtl,
556: ra_cust_trx_line_gl_dist rld,
557: ce_bank_accounts cba,
558: ce_bank_acct_uses_all cbau
559: WHERE
560: hzp.party_id = hzca.party_id
561: AND hzca.cust_account_id = hzcas.cust_account_id

Line 779: ce_bank_accounts cba,

775: BEGIN
776: select cba.agency_location_code
777: into v_alc_code
778: from ar_receipt_method_accounts arma,
779: ce_bank_accounts cba,
780: ce_bank_acct_uses_all cbau
781: where arma.primary_flag = 'Y'
782: and arma.receipt_method_id = vc_receipt_method_id
783: and cbau.bank_acct_use_id = arma.remit_bank_acct_use_id