DBA Data[Home] [Help]

APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_RULE_DEFS_V

Line 600: FROM okc_rule_defs_v

596: */
597: -- /striping/
598: CURSOR l_rul_csr IS
599: SELECT MEANING
600: FROM okc_rule_defs_v
601: WHERE RULE_CODE = p_rul_rec.RULE_INFORMATION_CATEGORY;
602:
603: -- l_rule_def FND_LOOKUPS.MEANING%TYPE; -- /striping/
604: l_rule_def okc_rule_defs_v.MEANING%TYPE;

Line 604: l_rule_def okc_rule_defs_v.MEANING%TYPE;

600: FROM okc_rule_defs_v
601: WHERE RULE_CODE = p_rul_rec.RULE_INFORMATION_CATEGORY;
602:
603: -- l_rule_def FND_LOOKUPS.MEANING%TYPE; -- /striping/
604: l_rule_def okc_rule_defs_v.MEANING%TYPE;
605:
606:
607: l_dummy VARCHAR2(1);
608: l_optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE;

Line 1064: okc_rule_defs_v fnd1,

1060: rgp.chr_id, rgp.cle_id,
1061: rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
1062: fnd1.meaning rule_name
1063: FROM FND_LOOKUPS fnd,
1064: okc_rule_defs_v fnd1,
1065: OKC_RG_DEF_RULES rgr,
1066: OKC_RULE_GROUPS_B rgp
1067: WHERE rgp.dnz_chr_id = p_chr_id
1068: AND fnd.lookup_code = rgp.rgd_code