DBA Data[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on HZ_CUST_ACCOUNTS

Line 90: from hz_parties party, hz_cust_accounts cust_acct

86: where customer_id = p_hold_entity_id;
87: */
88: CURSOR customer_value_cur IS
89: select substrb(party.party_name,1,50) customer_name
90: from hz_parties party, hz_cust_accounts cust_acct
91: where party.party_id = cust_acct.party_id
92: AND cust_acct.cust_account_id = p_hold_entity_id;
93:
94: CURSOR ship_to_value_cur IS