APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on ZX_PARTY_TAX_PROFILE

Line 917: ZX_PARTY_TAX_PROFILE ZP

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

Line 928: ZX_PARTY_TAX_PROFILE ZP

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