3347: Cursor salesP_csr( chrId NUMBER) IS
3348: select ct.object1_id1 id
3349: from okc_contacts ct,
3350: okc_contact_sources csrc,
3351: okc_k_party_roles_b pty,
3352: okc_k_headers_b chr
3353: where ct.cpl_id = pty.id
3354: and ct.cro_code = csrc.cro_code
3355: and ct.jtot_object1_code = csrc.jtot_object_code
3950: Cursor salesP_csr( chrId NUMBER) IS
3951: select ct.object1_id1 id
3952: from okc_contacts ct,
3953: okc_contact_sources csrc,
3954: okc_k_party_roles_b pty,
3955: okc_k_headers_b chr
3956: where ct.cpl_id = pty.id
3957: and ct.cro_code = csrc.cro_code
3958: and ct.jtot_object1_code = csrc.jtot_object_code
6011: Cursor salesP_csr( chrId NUMBER) IS
6012: select ct.object1_id1 id
6013: from okc_contacts ct,
6014: okc_contact_sources csrc,
6015: okc_k_party_roles_b pty,
6016: okc_k_headers_b chr
6017: where ct.cpl_id = pty.id
6018: and ct.cro_code = csrc.cro_code
6019: and ct.jtot_object1_code = csrc.jtot_object_code