APPS.OE_CNCL_VALUE_TO_ID dependencies on HZ_PARTIES

Line 2153: HZ_PARTIES Party where Cust_Acct.Party_id = Party.party_id and

2149: FROM OE_SOLD_TO_ORGS_V
2150: WHERE NAME = p_sold_to_org;*/
2151:
2152: Select Cust_Acct.Cust_account_id into l_id from HZ_CUST_ACCOUNTS Cust_Acct,
2153: HZ_PARTIES Party where Cust_Acct.Party_id = Party.party_id and
2154: Party.Party_name = p_sold_to_org;
2155:
2156:
2157: END IF;

Line 5454: HZ_PARTIES Party

5450: ELSE
5451: Select Cust_Acct.Cust_account_id
5452: into l_id
5453: from HZ_CUST_ACCOUNTS Cust_Acct,
5454: HZ_PARTIES Party
5455: where Cust_Acct.Party_id = Party.party_id
5456: and Party.Party_name = p_end_customer;
5457:
5458: END IF;