DBA Data[Home] [Help]

APPS.OKL_DEAL_TERMS_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 757: hz_cust_site_uses_all csu

753: CURSOR c_bill_to(p_chr_id NUMBER) IS
754: SELECT chr.bill_to_site_use_id,
755: csu.location bill_to_site_name
756: FROM okc_k_headers_b chr,
757: hz_cust_site_uses_all csu
758: WHERE chr.id = p_chr_id
759: AND csu.site_use_id = chr.bill_to_site_use_id;
760:
761: CURSOR c_rule(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rule_info_cat VARCHAR2) IS