APPS.OKS_ARFEEDER_PUB dependencies on HZ_CUST_SITE_USES

Line 871: from hz_cust_site_uses_all uses

867: where hz.party_site_id in (
868: SELECT site.party_site_id from hz_cust_acct_sites_all site
869: where site.cust_acct_site_id in
870: ( select uses.cust_acct_site_id
871: from hz_cust_site_uses_all uses
872: where site_use_id = p_bill_to_site_use_id
873: and site_use_code = 'BILL_TO')
874: and nvl(site.org_id,p_org_id) = p_org_id);
875:

Line 933: from hz_cust_site_uses_all uses

929: p_org_id IN NUMBER) IS
930: SELECT site.cust_account_id from hz_cust_acct_sites_all site
931: where site.cust_acct_site_id in
932: ( select uses.cust_acct_site_id
933: from hz_cust_site_uses_all uses
934: where site_use_id = p_bill_to_site_use_id
935: and site_use_code = 'BILL_TO')
936: and nvl(site.org_id,p_org_id) = p_org_id;
937:

Line 2211: hz_cust_site_uses_all cs

2207: FROM hz_locations l,
2208: hz_party_sites ps,
2209: hz_cust_accounts hca,
2210: hz_cust_acct_sites_all ca,
2211: hz_cust_site_uses_all cs
2212: WHERE cs.site_use_id = p_id
2213: AND cs.site_use_code = p_code
2214: AND ca.cust_acct_site_id = cs.cust_acct_site_id
2215: AND ps.location_id = l.location_id

Line 2464: from hz_cust_site_uses_all uses

2460: p_cust_account_id IN NUMBER) IS
2461: SELECT site.cust_account_id from hz_cust_acct_sites_all site
2462: where site.cust_acct_site_id in
2463: ( select uses.cust_acct_site_id
2464: from hz_cust_site_uses_all uses
2465: where site_use_id = p_bill_to_site_use_id
2466: and site_use_code = 'BILL_TO')
2467: and nvl(site.org_id,p_org_id) = p_org_id
2468: and site.cust_account_id = p_cust_account_id;

Line 2645: hz_cust_site_uses b,

2641: CURSOR tax_info_csr(p_site_use_id IN NUMBER) IS
2642: SELECT c.party_id,
2643: a.party_site_id
2644: FROM hz_cust_acct_sites a,
2645: hz_cust_site_uses b,
2646: hz_party_sites c
2647: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2648: AND c.party_site_id = a.party_site_id
2649: AND b.site_use_id = p_site_use_id;