APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on ZX_PARTY_TAX_PROFILE

Line 916: ZX_PARTY_TAX_PROFILE ZP

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
920: ZP.PARTY_ID = PS.PARTY_SITE_ID AND

Line 927: ZX_PARTY_TAX_PROFILE ZP

923: cursor get_vat_reg_num_cust (c_cust_id number) is
924: SELECT ZP.PARTY_TAX_PROFILE_ID,Upper(PARTY.TAX_REFERENCE)
925: FROM HZ_CUST_ACCOUNTS CA,
926: HZ_PARTIES PARTY,
927: ZX_PARTY_TAX_PROFILE ZP
928: WHERE CA.CUST_ACCOUNT_ID = c_cust_id AND
929: CA.PARTY_ID = PARTY.PARTY_ID AND
930: PARTY.PARTY_ID = ZP.PARTY_ID AND
931: ZP.PARTY_TYPE_CODE = 'THIRD_PARTY';