DBA Data[Home] [Help]

APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on HZ_CUST_ACCOUNTS

Line 926: FROM HZ_CUST_ACCOUNTS CA,

922: ZP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE';
923:
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