DBA Data[Home] [Help]

APPS.OKS_IB_UTIL_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1013: ,Hz_Cust_Acct_Sites_All Ca,

1009: Cursor Check_address_csr(l_site_use_id Number,l_party_id Number, l_account_id number, l_org_id number, l_site_use_code varchar2) Is
1010: Select Cs.Site_Use_Id
1011: , Arp_Addr_Label_Pkg.Format_Address(Null,L.Address1,L.Address2,L.Address3, L.Address4, L.City, L.County, L.State, L.Province, L.Postal_Code, Null, L.Country, Null, Null, Null, Null, Null, Null, Null, 'N', 'N', 300, 1, 1) Address
1012: From Hz_Party_Sites Ps,Hz_Locations L
1013: ,Hz_Cust_Acct_Sites_All Ca,
1014: Hz_Cust_Site_Uses_All Cs
1015: Where Ps.Location_Id = L.Location_Id
1016: And L.Content_Source_Type = 'USER_ENTERED'
1017: And Ps.Party_Site_Id = Ca.Party_Site_Id