APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 490: hz_cust_site_uses_all site_use,

486:
487: CURSOR c_cust_number (p_header_id IN NUMBER) IS
488: SELECT cust.cust_account_id
489: FROM hz_cust_acct_sites_all acct_site,
490: hz_cust_site_uses_all site_use,
491: hz_cust_accounts cust,
492: oe_order_headers_all header
493: WHERE header.header_id = p_header_id
494: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 547: FROM hz_cust_site_uses_all

543:
544: -- get sites org id type
545: CURSOR c_org_id (p_site_use_id IN NUMBER) IS
546: SELECT org_id
547: FROM hz_cust_site_uses_all
548: WHERE site_use_id = p_site_use_id;
549:
550: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
551: SELECT autopay_party_attr,autopay_party_id

Line 918: hz_cust_site_uses_all b

914:
915: CURSOR party_site_id_csr(p_account_site_id IN NUMBER) IS
916: SELECT a.party_site_id
917: FROM hz_cust_acct_sites_all a,
918: hz_cust_site_uses_all b
919: WHERE b.site_use_id = p_account_site_id
920: AND b.cust_acct_site_id = a.cust_acct_site_id;
921:
922: CURSOR sales_transation_csr(p_line_id IN NUMBER) IS

Line 945: hz_cust_site_uses_all site_use,

941:
942: CURSOR c_cust_number (p_header_id IN NUMBER) IS
943: SELECT cust.cust_account_id
944: FROM hz_cust_acct_sites_all acct_site,
945: hz_cust_site_uses_all site_use,
946: hz_cust_accounts cust,
947: oe_order_headers_all header
948: WHERE header.header_id = p_header_id
949: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 4728: hz_cust_site_uses_all site_use,

4724:
4725: CURSOR c_cust_number (p_header_id IN NUMBER) IS
4726: SELECT cust.cust_account_id
4727: FROM hz_cust_acct_sites_all acct_site,
4728: hz_cust_site_uses_all site_use,
4729: hz_cust_accounts cust,
4730: oe_order_headers_all header
4731: WHERE header.header_id = p_header_id
4732: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id