APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on HZ_PARTY_SITES

Line 758: from HZ_PARTY_SITES PARTY_SITE,

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

Line 916: HZ_PARTY_SITES PS,

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