APPS.OKS_SETUP_UTIL_PUB dependencies on OKX_CUST_SITES_V

Line 3823: FROM okx_cust_sites_v loc

3819: SELECT
3820: loc.ADDRESS1||''||loc.ADDRESS2||''||loc.ADDRESS3||''||loc.ADDRESS4 Address
3821: ,loc.CITY||' '||loc.state||' '||loc.postal_code city
3822: ,loc.country
3823: FROM okx_cust_sites_v loc
3824: WHERE id1 = l_site_id ;
3825:
3826: l_hdr_svc_rec l_hdr_svc_csr%ROWTYPE;
3827: hdr_qto_rec hdr_qto_csr%ROWTYPE;

Line 3925: from okx_cust_sites_v a,

3921: x_msg_data OUT NOCOPY VARCHAR2) IS
3922: -- Contact address
3923: cursor address_cur_new is
3924: select a.id1
3925: from okx_cust_sites_v a,
3926: okx_cust_contacts_v b
3927: where b.id1 = p_contact_id
3928: and a.id1 = b.cust_acct_site_id;
3929: