APPS.OKE_FORM_DD250 dependencies on HZ_PARTIES

Line 645: , hz_parties p

641: rpad(nvl(p.Postal_Code,' ') , 80 , ' ') || /* Postal_Code */
642: rpad(nvl(p.Country,' ') , 80 , ' ') /* Country_Code */
643: Address
644: FROM hz_cust_accounts c
645: , hz_parties p
646: WHERE c.cust_account_id = C_Cust_Acct_ID
647: AND p.party_id = c.party_id;
648:
649: CURSOR CustSiteAddr ( C_Site_ID NUMBER ) IS