DBA Data[Home] [Help]

APPS.OKC_RUL_PVT dependencies on OKC_K_HEADERS_B

Line 341: FROM OKC_K_HEADERS_B chrv

337: ) IS
338: l_dummy_var VARCHAR2(1) := '?';
339: CURSOR l_chrv_csr IS
340: SELECT 'x'
341: FROM OKC_K_HEADERS_B chrv
342: WHERE chrv.ID = p_rulv_rec.DNZ_CHR_ID;
343: --
344: l_proc varchar2(72) := g_package||'validate_dnz_chr_id';
345: --

Line 6503: FROM OKC_K_HEADERS_B K ,

6499: AND dfcu.application_id = p_appl_id
6500: AND dfcu.descriptive_flex_context_code IN
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

Line 6584: FROM OKC_K_HEADERS_B K ,

6580: AND dfcu.application_id = p_appl_id
6581: AND dfcu.descriptive_flex_context_code IN
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