APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 1280: OKC_K_PARTY_ROLES_B cplb,

1276: p_asset_cle_id in number) is
1277: select 'Y'
1278: from RA_SALESREP_TERRITORIES rst,
1279: OKC_CONTACTS cro,
1280: OKC_K_PARTY_ROLES_B cplb,
1281: OKC_K_LINES_B cleb,
1282: okl_subsidy_criteria suc
1283: Where
1284: rst.salesrep_id = cro.object1_id1

Line 3828: from okc_k_party_roles_b cplb

3824: cursor l_cplb_csr (p_subsidy_cle_id in number,
3825: p_cpl_id in number
3826: ) is
3827: select 'Y'
3828: from okc_k_party_roles_b cplb
3829: where cplb.id = p_cpl_id
3830: and cplb.cle_id = p_subsidy_cle_id
3831: and cplb.rle_code = 'OKL_VENDOR';
3832:

Line 3839: from okc_k_party_roles_b cplb

3835: --required only for lease.not for quote
3836: cursor l_vendor_csr (p_chr_id in number,
3837: p_vendor_id in number) is
3838: select 'Y'
3839: from okc_k_party_roles_b cplb
3840: where cplb.chr_id = p_chr_id
3841: and cplb.dnz_chr_id = p_chr_id
3842: and cplb.rle_code = 'OKL_VENDOR'
3843: and cplb.object1_id1 = to_char(p_vendor_id)

Line 4028: from okc_k_party_roles_b cplb

4024: cursor l_cplb_csr (p_subsidy_cle_id in number,
4025: p_cpl_id in number
4026: ) is
4027: select 'Y'
4028: from okc_k_party_roles_b cplb
4029: where cplb.id = p_cpl_id
4030: and cplb.cle_id = p_subsidy_cle_id
4031: and cplb.rle_code = 'OKL_VENDOR';
4032:

Line 4685: -- okc_k_party_roles_b and okl_k_party_roles

4681: l_cplv_rec.cle_id := lx_clev_rec.id;
4682:
4683: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4684: -- to create records in tables
4685: -- okc_k_party_roles_b and okl_k_party_roles
4686: /*
4687: okl_okc_migration_pvt.create_k_party_role(
4688: p_api_version => p_api_version,
4689: p_init_msg_list => p_init_msg_list,

Line 5234: -- okc_k_party_roles_b and okl_k_party_roles

5230: l_cplv_rec.id := OKL_API.G_MISS_NUM;
5231:
5232: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
5233: -- to create records in tables
5234: -- okc_k_party_roles_b and okl_k_party_roles
5235:
5236: /*
5237: okl_okc_migration_pvt.create_k_party_role(
5238: p_api_version => p_api_version,

Line 5268: -- okc_k_party_roles_b and okl_k_party_roles

5264: Elsif l_cplv_rec.id is not null then
5265: --update
5266: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
5267: -- to update records in tables
5268: -- okc_k_party_roles_b and okl_k_party_roles
5269: /*
5270: okl_okc_migration_pvt.update_k_party_role(
5271: p_api_version => p_api_version,
5272: p_init_msg_list => p_init_msg_list,

Line 5633: -- okc_k_party_roles_b and okl_k_party_roles

5629: l_cplv_rec.id := l_db_asb_rec.cpl_id;
5630:
5631: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
5632: -- to delete records in tables
5633: -- okc_k_party_roles_b and okl_k_party_roles
5634: /*
5635: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
5636: p_api_version => p_api_version,
5637: p_init_msg_list => p_init_msg_list,