APPS.OE_HEADER_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 9671: FROM HZ_CUST_SITE_USES_ALL site,

9667: x_city,
9668: x_state,
9669: x_zip,
9670: x_country
9671: FROM HZ_CUST_SITE_USES_ALL site,
9672: HZ_CUST_ACCT_SITES cas,
9673: hz_cust_accounts cust,
9674: hz_parties party,
9675: hz_party_sites ps,

Line 10151: FROM HZ_CUST_SITE_USES_ALL site_use,

10147: BEGIN
10148: IF p_site_use = 'SHIP_TO' THEN
10149: SELECT site_use.SITE_USE_ID
10150: INTO p_site_use_id
10151: FROM HZ_CUST_SITE_USES_ALL site_use,
10152: HZ_CUST_ACCT_SITES site
10153: WHERE site_use.SITE_USE_CODE = p_site_use
10154: AND site.CUST_ACCT_SITE_ID = site_use.CUST_ACCT_SITE_ID
10155: AND site.CUST_ACCOUNT_ID = p_cust_acct_id

Line 10164: FROM HZ_CUST_SITE_USES_ALL site_use,

10160: AND SITE.ORG_ID = p_org_id;
10161: ELSE
10162: SELECT site_use.SITE_USE_ID
10163: INTO p_site_use_id
10164: FROM HZ_CUST_SITE_USES_ALL site_use,
10165: HZ_CUST_ACCT_SITES site
10166: WHERE site_use.SITE_USE_CODE = p_site_use
10167: AND site.CUST_ACCT_SITE_ID = site_use.CUST_ACCT_SITE_ID
10168: AND site.CUST_ACCOUNT_ID = p_cust_acct_id