APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on HZ_PARTY_SITES

Line 757: from HZ_PARTY_SITES PARTY_SITE,

753: loc.COUNTY,
754: loc.PROVINCE,
755: loc.CITY,
756: acct_site.CUST_ACCT_SITE_ID
757: from HZ_PARTY_SITES PARTY_SITE,
758: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
759: HZ_LOCATIONS LOC,
760: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
761: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND

Line 915: HZ_PARTY_SITES PS,

911: cursor get_vat_reg_num_site (c_site_use_id number) is
912: SELECT ZP.PARTY_TAX_PROFILE_ID,Upper(SU.TAX_REFERENCE)
913: FROM HZ_CUST_SITE_USES_ALL SU,
914: HZ_CUST_ACCT_SITES_ALL CAS,
915: HZ_PARTY_SITES PS,
916: ZX_PARTY_TAX_PROFILE ZP
917: WHERE SU.SITE_USE_ID = c_site_use_id AND
918: SU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID AND
919: CAS.PARTY_SITE_ID = PS.PARTY_SITE_ID AND