DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_SUBCLASS_ROLES

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 4606: okc_subclass_roles sre,

4602:
4603: Cursor c_rrd_id (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) is
4604: SELECT rgrdfs.id
4605: from okc_k_headers_b chr,
4606: okc_subclass_roles sre,
4607: okc_role_sources rse,
4608: okc_subclass_rg_defs rgdfs,
4609: okc_rg_role_defs rgrdfs
4610: where chr.id = cp_chr_id