1245: --
1246: -- Following query is changed as per TCA obsolescence project.
1247: select PARTY.PARTY_NAME
1248: into temp_cust 1249: from HZ_PARTIES PARTY, 1250: HZ_CUST_ACCOUNTS CUST_ACCT
1251: where CUST_ACCT.CUST_ACCOUNT_ID = p_customer
1252: and CUST_ACCT.PARTY_ID = PARTY.PARTY_ID;
1253: --