DBA Data[Home] [Help]

APPS.RCV_RETURN_SV dependencies on HZ_CUST_ACCOUNTS

Line 98: from HZ_CUST_ACCOUNTS HZCA,

94: * into char in different languages.
95: */
96: cursor get_customer(p_customer_id in varchar2) is
97: select SUBSTRB(HZP.PARTY_NAME,1,50)
98: from HZ_CUST_ACCOUNTS HZCA,
99: HZ_PARTIES HZP
100: where HZCA.CUST_ACCOUNT_ID = p_customer_id
101: and HZCA.PARTY_ID = HZP.PARTY_ID
102: AND ROWNUM<=1;