DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 3351: okc_k_party_roles_b pty,

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

Line 3954: okc_k_party_roles_b pty,

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

Line 6015: okc_k_party_roles_b pty,

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