APPS.OKS_SETUP_UTIL_PUB dependencies on OKX_CUST_SITES_V

Line 3832: FROM okx_cust_sites_v loc

3828: SELECT
3829: loc.ADDRESS1||''||loc.ADDRESS2||''||loc.ADDRESS3||''||loc.ADDRESS4 Address
3830: ,loc.CITY||' '||loc.state||' '||loc.postal_code city
3831: ,loc.country
3832: FROM okx_cust_sites_v loc
3833: WHERE id1 = l_site_id ;
3834:
3835: l_hdr_svc_rec l_hdr_svc_csr%ROWTYPE;
3836: hdr_qto_rec hdr_qto_csr%ROWTYPE;

Line 3934: from okx_cust_sites_v a,

3930: x_msg_data OUT NOCOPY VARCHAR2) IS
3931: -- Contact address
3932: cursor address_cur_new is
3933: select a.id1
3934: from okx_cust_sites_v a,
3935: okx_cust_contacts_v b
3936: where b.id1 = p_contact_id
3937: and a.id1 = b.cust_acct_site_id;
3938: