APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 4524: FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES

4520: AND buy_or_sell = 'S';
4521: --Get the vendor id
4522: CURSOR c_cplv (p_khr_id IN okl_lease_applications_v.PROGRAM_AGREEMENT_ID%TYPE) IS
4523: SELECT cpl.id, cpl.object1_id1
4524: FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES
4525: WHERE dnz_chr_id = p_khr_id
4526: AND cpl.rle_code = ROLES.rle_code
4527: AND cpl.rle_code = 'OKL_VENDOR'
4528: AND ROLES.scs_code = 'LEASE'

Line 4559: , p_rle_code okc_k_party_roles_b.RLE_CODE%TYPE

4555: AND hzp.party_id = gdata.party_id;
4556:
4557: -- Cursor checks if party already exists
4558: CURSOR c_chk_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE
4559: , p_rle_code okc_k_party_roles_b.RLE_CODE%TYPE
4560: , p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE) IS
4561: SELECT 1
4562: FROM okc_k_party_roles_b p_role
4563: WHERE p_role.dnz_chr_id = p_chr_id

Line 4560: , p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE) IS

4556:
4557: -- Cursor checks if party already exists
4558: CURSOR c_chk_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE
4559: , p_rle_code okc_k_party_roles_b.RLE_CODE%TYPE
4560: , p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE) IS
4561: SELECT 1
4562: FROM okc_k_party_roles_b p_role
4563: WHERE p_role.dnz_chr_id = p_chr_id
4564: AND p_role.rle_code = p_rle_code

Line 4562: FROM okc_k_party_roles_b p_role

4558: CURSOR c_chk_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE
4559: , p_rle_code okc_k_party_roles_b.RLE_CODE%TYPE
4560: , p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE) IS
4561: SELECT 1
4562: FROM okc_k_party_roles_b p_role
4563: WHERE p_role.dnz_chr_id = p_chr_id
4564: AND p_role.rle_code = p_rle_code
4565: AND p_role.object1_id1 = p_object1_id1;
4566:

Line 4569: , p_rle_code okc_k_party_roles_b.RLE_CODE%TYPE) IS

4565: AND p_role.object1_id1 = p_object1_id1;
4566:
4567: -- Cursor to get specific parties of the contract template
4568: CURSOR c_get_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE
4569: , p_rle_code okc_k_party_roles_b.RLE_CODE%TYPE) IS
4570: SELECT p_role.ID,
4571: p_role.object1_id1,
4572: p_role.object1_id2,
4573: p_role.jtot_object1_code,

Line 4575: FROM okc_k_party_roles_b p_role

4571: p_role.object1_id1,
4572: p_role.object1_id2,
4573: p_role.jtot_object1_code,
4574: p_role.rle_code
4575: FROM okc_k_party_roles_b p_role
4576: WHERE p_role.dnz_chr_id = p_chr_id
4577: AND p_role.rle_code = p_rle_code;
4578:
4579: -- Cursor to get parties of the contract template - parties other than Lessee, Lessor, Vendor

Line 4588: FROM okc_k_party_roles_b p_role

4584: p_role.object1_id1,
4585: p_role.object1_id2,
4586: p_role.jtot_object1_code,
4587: p_role.rle_code
4588: FROM okc_k_party_roles_b p_role
4589: WHERE p_role.dnz_chr_id = p_chr_id
4590: AND (p_role.rle_code NOT IN ('LESSEE', 'LESSOR', 'OKL_VENDOR')
4591: OR (p_role.rle_code = 'GUARANTOR'
4592: AND p_role.jtot_object1_code= 'OKX_PARTY'