APPS.FV_SF1081_TRANSACTION dependencies on HZ_CUST_ACCT_SITES

Line 413: vc_address_id hz_cust_acct_sites.cust_acct_site_id%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;
417: vc_city hz_locations.city%TYPE;

Line 455: HZ_CUST_ACCT_SITES HZCAS,

451: RA_CUSTOMER_TRX_LINES RTL,
452: RA_CUST_TRX_LINE_GL_DIST RLD,
453: HZ_CUST_SITE_USES HZCSU,
454: HZ_LOCATIONS HZL,
455: HZ_CUST_ACCT_SITES HZCAS,
456: HZ_CUST_ACCOUNTS HZCA,
457: HZ_PARTY_SITES HZPS,
458: HZ_PARTIES HZP
459: WHERE

Line 549: hz_cust_acct_sites hzcas,

545: rct.trx_date,
546: rld.code_combination_id
547: FROM
548: hz_locations hzl,
549: hz_cust_acct_sites hzcas,
550: hz_party_sites hzps ,
551: HZ_CUST_SITE_USEs hzcsu,
552: hz_cust_accounts hzca,
553: hz_parties hzp,

Line 711: FROM hz_cust_acct_sites_all hzcas,

707: BEGIN
708:
709: SELECT eb.agency_location_code
710: INTO vc_cust_alc
711: FROM hz_cust_acct_sites_all hzcas,
712: hz_cust_site_uses_all hzcsu,
713: iby_external_payers_all payer,
714: iby_pmt_instr_uses_all iby_ins,
715: iby_ext_bank_accounts_v eb