2346: AND rle_code in ('CUSTOMER','SUBSCRIBER');
2347:
2348: Cursor get_contacts(p_cpl_id number)IS
2349: SELECT id
2350: FROM Okc_contacts
2351: WHERE cpl_id = p_cpl_id;
2352:
2353: get_topline_rec get_toplines%Rowtype;
2354: --get_qto_rec get_qto%rowtype;
3783: SELECT ctc.object1_id1 ,
3784: pt.name contact_name,
3785: pt.party_id,
3786: hz.party_name party_name
3787: FROM okc_contacts_v ctc,
3788: okx_party_contacts_v pt,
3789: hz_parties hz
3790: WHERE ctc.cro_code = 'SVC_ADMIN'
3791: AND ctc.dnz_chr_id = p_chr_id