DBA Data[Home] [Help]

APPS.IBE_ORDER_SAVE_PVT dependencies on HZ_PARTY_SITES

Line 1175: from hz_cust_acct_sites hca,hz_cust_site_uses hcu,hz_party_sites hps

1171: Declare
1172: cursor c_cust_acct_id (lin_custacct_siteuse_id number, lin_siteuse_type varchar2)
1173: is
1174: select hca.cust_acct_site_id, hca.cust_account_id,hps.party_id
1175: from hz_cust_acct_sites hca,hz_cust_site_uses hcu,hz_party_sites hps
1176: where
1177: hcu.site_use_id = lin_custacct_siteuse_id
1178: and hcu.site_use_code = lin_siteuse_type
1179: and hcu.cust_acct_site_id = hca.cust_acct_site_id