APPS.OKC_RUL_PVT dependencies on OKC_RG_DEF_RULES

Line 537: OKC_RG_DEF_RULES rgrv

533:
534: CURSOR l_rgrv_csr IS
535: SELECT 'x'
536: FROM OKC_RULE_GROUPS_B rgpv,
537: OKC_RG_DEF_RULES rgrv
538: WHERE rgrv.RGD_CODE = rgpv.RGD_CODE
539: AND rgpv.ID = p_rulv_rec.rgp_id
540: AND rgrv.RDF_CODE = p_rulv_rec.rule_information_category;
541: --

Line 6505: okc_rg_def_rules A

6501: (
6502: SELECT /*+ NO_UNNEST */ rdf_code
6503: FROM OKC_K_HEADERS_B K ,
6504: okc_subclass_rg_defs B,
6505: okc_rg_def_rules A
6506: WHERE A.rgd_code = B.rgd_code
6507: AND B.scs_code = K.scs_code
6508: AND k.id = p_rulv_rec.dnz_chr_id
6509: )

Line 6586: okc_rg_def_rules A

6582: (
6583: SELECT /*+ NO_UNNEST */ rdf_code
6584: FROM OKC_K_HEADERS_B K ,
6585: okc_subclass_rg_defs B,
6586: okc_rg_def_rules A
6587: WHERE A.rgd_code = B.rgd_code
6588: AND B.scs_code = K.scs_code
6589: AND k.id = p_rulv_rec.dnz_chr_id
6590: )