DBA Data[Home] [Help]

APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on HZ_CUST_ACCOUNTS

Line 925: FROM HZ_CUST_ACCOUNTS CA,

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