eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_RULE_GROUPS_B

Line 261: FROM okc_rule_groups_b rgp

257: AND object1_id2 = l_cpl1_rec.object1_id2;
258: --bug 2398639
259: CURSOR l_ph_can_rule(b_chr_id number) IS
260: SELECT 'Y'
261: FROM okc_rule_groups_b rgp
262: ,okc_rules_b rul
263: WHERE rgp.dnz_chr_id = b_chr_id
264: AND rgp.cle_id IS NULL
265: AND rul.rgp_id = rgp.id

Line 566: p_rgd_code IN OKC_RULE_GROUPS_B.rgd_code%TYPE,

562:
563: PROCEDURE check_rule_values(
564: x_return_status OUT NOCOPY VARCHAR2,
565: p_rul_rec IN OKC_RULES_B%ROWTYPE,
566: p_rgd_code IN OKC_RULE_GROUPS_B.rgd_code%TYPE,
567: p_rgp_id IN OKC_RULE_GROUPS_B.id%TYPE,
568: p_chr_id IN OKC_RULE_GROUPS_B.chr_id%TYPE,
569: p_cle_id IN OKC_RULE_GROUPS_B.cle_id%TYPE,
570: p_cls_code IN OKC_SUBCLASSES_B.CLS_CODE%TYPE

Line 567: p_rgp_id IN OKC_RULE_GROUPS_B.id%TYPE,

563: PROCEDURE check_rule_values(
564: x_return_status OUT NOCOPY VARCHAR2,
565: p_rul_rec IN OKC_RULES_B%ROWTYPE,
566: p_rgd_code IN OKC_RULE_GROUPS_B.rgd_code%TYPE,
567: p_rgp_id IN OKC_RULE_GROUPS_B.id%TYPE,
568: p_chr_id IN OKC_RULE_GROUPS_B.chr_id%TYPE,
569: p_cle_id IN OKC_RULE_GROUPS_B.cle_id%TYPE,
570: p_cls_code IN OKC_SUBCLASSES_B.CLS_CODE%TYPE
571: ) IS

Line 568: p_chr_id IN OKC_RULE_GROUPS_B.chr_id%TYPE,

564: x_return_status OUT NOCOPY VARCHAR2,
565: p_rul_rec IN OKC_RULES_B%ROWTYPE,
566: p_rgd_code IN OKC_RULE_GROUPS_B.rgd_code%TYPE,
567: p_rgp_id IN OKC_RULE_GROUPS_B.id%TYPE,
568: p_chr_id IN OKC_RULE_GROUPS_B.chr_id%TYPE,
569: p_cle_id IN OKC_RULE_GROUPS_B.cle_id%TYPE,
570: p_cls_code IN OKC_SUBCLASSES_B.CLS_CODE%TYPE
571: ) IS
572:

Line 569: p_cle_id IN OKC_RULE_GROUPS_B.cle_id%TYPE,

565: p_rul_rec IN OKC_RULES_B%ROWTYPE,
566: p_rgd_code IN OKC_RULE_GROUPS_B.rgd_code%TYPE,
567: p_rgp_id IN OKC_RULE_GROUPS_B.id%TYPE,
568: p_chr_id IN OKC_RULE_GROUPS_B.chr_id%TYPE,
569: p_cle_id IN OKC_RULE_GROUPS_B.cle_id%TYPE,
570: p_cls_code IN OKC_SUBCLASSES_B.CLS_CODE%TYPE
571: ) IS
572:
573: CURSOR l_cti_csr IS

Line 1029: FROM OKC_RULE_GROUPS_B rgp, OKC_RULES_B rul

1025: -- = 'CURRENCY' for core contracts
1026: --
1027: CURSOR l_cvn_csr(p_rgd_code VARCHAR2) IS
1028: SELECT 'x'
1029: FROM OKC_RULE_GROUPS_B rgp, OKC_RULES_B rul
1030: WHERE rgp.rgd_code = p_rgd_code
1031: AND rgp.dnz_chr_id = p_chr_id
1032: AND rul.dnz_chr_id = rgp.dnz_chr_id
1033: AND rgp.cle_id is null

Line 1048: OKC_RULE_GROUPS_B rgp

1044: fnd1.meaning rule_name
1045: FROM FND_LOOKUPS fnd,
1046: FND_LOOKUPS fnd1,
1047: OKC_RG_DEF_RULES rgr,
1048: OKC_RULE_GROUPS_B rgp
1049: WHERE rgp.dnz_chr_id = p_chr_id
1050: AND fnd.lookup_code = rgp.rgd_code
1051: AND fnd.lookup_type = 'OKC_RULE_GROUP_DEF'
1052: AND rgr.rgd_code = rgp.rgd_code

Line 1066: OKC_RULE_GROUPS_B rgp

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
1069: AND fnd.lookup_type = 'OKC_RULE_GROUP_DEF'
1070: AND rgr.rgd_code = rgp.rgd_code

Line 1383: OKC_RULE_GROUPS_B rgp,

1379: FND_LOOKUPS fndrgd,
1380: OKC_SUBCLASS_ROLES sre,
1381: OKC_RG_ROLE_DEFS rrd,
1382: OKC_SUBCLASS_RG_DEFS srd,
1383: OKC_RULE_GROUPS_B rgp,
1384: OKC_K_HEADERS_B chr
1385: WHERE fndrle.LOOKUP_CODE = sre.rle_code
1386: AND fndrle.LOOKUP_TYPE = 'OKC_ROLE'
1387: AND fndrgd.LOOKUP_CODE = srd.rgd_code