APPS.OKS_ARFEEDER_PUB dependencies on HZ_CUST_ACCT_SITES

Line 868: SELECT site.party_site_id from hz_cust_acct_sites_all site

864: Cursor hdr_party_cur(p_bill_to_site_use_id IN NUMBER,
865: p_org_id IN NUMBER) IS
866: SELECT hz.party_id from hz_party_sites hz
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

Line 930: SELECT site.cust_account_id from hz_cust_acct_sites_all site

926: AND rl.org_id = p_org_id;
927:
928: Cursor cur_cust_account(p_bill_to_site_use_id IN NUMBER,
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

Line 2210: hz_cust_acct_sites_all ca,

2206: l.location_id ,hca.party_id ,cs.site_use_iD
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

Line 2461: SELECT site.cust_account_id from hz_cust_acct_sites_all site

2457:
2458: Cursor check_for_account_id(p_bill_to_site_use_id IN NUMBER,
2459: p_org_id IN NUMBER,
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

Line 2644: FROM hz_cust_acct_sites a,

2640:
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