DBA Data[Home] [Help]

APPS.OKL_COPY_ASSET_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 3750: okc_k_party_roles_b cplb,

3746: ,ppyd.ATTRIBUTE14
3747: ,ppyd.ATTRIBUTE15
3748: ,cleb_sub.id subsidy_cle_id
3749: from okl_party_payment_dtls ppyd,
3750: okc_k_party_roles_b cplb,
3751: okc_k_lines_b cleb_sub
3752: where ppyd.cpl_id = cplb.id
3753: and cplb.cle_id = cleb_sub.id
3754: and cleb_sub.cle_id = p_from_cle_id

Line 3763: from okc_k_party_roles_b cplb,

3759: --cursor to get party role record from new line
3760: cursor l_cplb_csr (p_to_cle_id in number,
3761: p_parent_cle_id in number)is
3762: select cplb.id
3763: from okc_k_party_roles_b cplb,
3764: okc_k_lines_b cleb_sub
3765: where cplb.cle_id = cleb_sub.id
3766: and cleb_sub.cle_id = p_to_cle_id
3767: and cleb_sub.orig_system_id1 = p_parent_cle_id