[Home] [Help]
APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on HZ_PARTIES
Line 926: HZ_PARTIES PARTY,
922:
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