DBA Data[Home] [Help]

APPS.OKL_VP_SYNC_CR_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 644: FROM okc_k_party_roles_v

640: ,creation_date
641: ,last_updated_by
642: ,last_update_date
643: ,last_update_login
644: FROM okc_k_party_roles_v
645: WHERE dnz_chr_id = cp_chr_id
646: AND jtot_object1_code = 'OKX_PARTY'; -- this indicates non primary parties
647:
648: CURSOR c_get_party_info_csr(cp_chr_id okc_k_headers_b.id%TYPE

Line 677: FROM okc_k_party_roles_v cpl

673: ,kpl.attribute13
674: ,kpl.attribute14
675: ,kpl.attribute15
676: */
677: FROM okc_k_party_roles_v cpl
678: /* ,okl_k_party_roles_v kpl */
679: WHERE cpl.dnz_chr_id = cp_chr_id
680: AND cpl.object1_id1 = cp_party_id
681: AND cpl.jtot_object1_code = 'OKX_PARTY'; -- this indicates non primary parties

Line 1368: okc_k_party_roles_v cplv,

1364: cplv.cognomen cognomen,
1365: cplv.alias alias,
1366: chrb.authoring_org_id authoring_org_id
1367: FROM okc_k_headers_b chrb,
1368: okc_k_party_roles_v cplv,
1369: hz_cust_accounts hzc,
1370: hz_cust_site_uses_all hzcsu,
1371: okc_rg_party_roles rgrp,
1372: okc_rule_groups_b rgpb,