APPS.OE_HOLDS_PVT dependencies on HZ_PARTIES

Line 144: from hz_parties party, hz_cust_accounts cust_acct

140: where customer_id = p_hold_entity_id;
141: */
142: CURSOR customer_value_cur IS
143: select substrb(party.party_name,1,50) customer_name
144: from hz_parties party, hz_cust_accounts cust_acct
145: where party.party_id = cust_acct.party_id
146: AND cust_acct.cust_account_id = p_hold_entity_id;
147:
148: CURSOR ship_to_value_cur IS