APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_CONTACTS

Line 2341: FROM Okc_contacts

2337: AND rle_code in ('CUSTOMER','SUBSCRIBER');
2338:
2339: Cursor get_contacts(p_cpl_id number)IS
2340: SELECT id
2341: FROM Okc_contacts
2342: WHERE cpl_id = p_cpl_id;
2343:
2344: get_topline_rec get_toplines%Rowtype;
2345: --get_qto_rec get_qto%rowtype;

Line 3778: FROM okc_contacts_v ctc,

3774: SELECT ctc.object1_id1 ,
3775: pt.name contact_name,
3776: pt.party_id,
3777: hz.party_name party_name
3778: FROM okc_contacts_v ctc,
3779: okx_party_contacts_v pt,
3780: hz_parties hz
3781: WHERE ctc.cro_code = 'SVC_ADMIN'
3782: AND ctc.dnz_chr_id = p_chr_id