DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_SUBCLASS_RG_DEFS

Line 4263: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs

4259: AND olav.ID = p_lap_id;
4260:
4261: CURSOR c_rgpv (p_chr_tmp_id okl_leaseapp_templ_versions_v.CONTRACT_TEMPLATE_ID%TYPE)IS
4262: SELECT rgp.id
4263: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs
4264: WHERE rgp.dnz_chr_id = p_chr_tmp_id
4265: AND rgp.rgd_code = rg_defs.rgd_code
4266: AND rg_defs.scs_code = 'LEASE'
4267: AND rgp.cle_id IS NULL

Line 4608: okc_subclass_rg_defs rgdfs,

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
4611: and sre.scs_code = chr.scs_code
4612: and sre.rle_code = rse.rle_code