DBA Data[Home] [Help]

APPS.OKC_RUL_PVT dependencies on OKC_RULE_GROUPS_B

Line 115: FROM OKC_RULE_GROUPS_B rgpv

111: ) IS
112: l_dummy_var VARCHAR2(1) := '?';
113: CURSOR l_rgpv_csr IS
114: SELECT 'x'
115: FROM OKC_RULE_GROUPS_B rgpv
116: WHERE rgpv.ID = p_rulv_rec.RGP_ID;
117: --
118: l_proc varchar2(72) := g_package||'validate_rgp_id';
119: --

Line 536: FROM OKC_RULE_GROUPS_B rgpv,

532: AND dfc.descriptive_flex_context_code = p_rulv_rec.rule_information_category;
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;