DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 3370: okc_k_party_roles_b pty,

3366: Cursor salesP_csr( chrId NUMBER) IS
3367: select ct.object1_id1 id
3368: from okc_contacts ct,
3369: okc_contact_sources csrc,
3370: okc_k_party_roles_b pty,
3371: okc_k_headers_b chr
3372: where ct.cpl_id = pty.id
3373: and ct.cro_code = csrc.cro_code
3374: and ct.jtot_object1_code = csrc.jtot_object_code

Line 3979: okc_k_party_roles_b pty,

3975: Cursor salesP_csr( chrId NUMBER) IS
3976: select ct.object1_id1 id
3977: from okc_contacts ct,
3978: okc_contact_sources csrc,
3979: okc_k_party_roles_b pty,
3980: okc_k_headers_b chr
3981: where ct.cpl_id = pty.id
3982: and ct.cro_code = csrc.cro_code
3983: and ct.jtot_object1_code = csrc.jtot_object_code

Line 6008: okc_k_party_roles_b pty,

6004: Cursor salesP_csr( chrId NUMBER) IS
6005: select ct.object1_id1 id
6006: from okc_contacts ct,
6007: okc_contact_sources csrc,
6008: okc_k_party_roles_b pty,
6009: okc_k_headers_b chr
6010: where ct.cpl_id = pty.id
6011: and ct.cro_code = csrc.cro_code
6012: and ct.jtot_object1_code = csrc.jtot_object_code