APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_RULE_GROUPS_B

Line 51: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

47: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QA_CHECK_PVT';
48: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
49: ---------------------------------------------------------------------------
50: cursor l_rl_csr( shid NUMBER,
51: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
52: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
53: chrId NUMBER,
54: cleId NUMBER ) IS
55: select crl.id slh_id,

Line 64: from OKC_RULE_GROUPS_B crg,

60: crl.RULE_INFORMATION5,
61: crl.RULE_INFORMATION6,
62: crl.RULE_INFORMATION7,
63: crl.RULE_INFORMATION10
64: from OKC_RULE_GROUPS_B crg,
65: OKC_RULES_B crl
66: where crl.object2_id1 = shid
67: and crl.rgp_id = crg.id
68: and crg.RGD_CODE = rgcode

Line 74: cursor l_rl_csr1( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

70: and crg.dnz_chr_id = chrId
71: and nvl(crg.cle_id,-1) = cleId
72: order by crl.RULE_INFORMATION1;
73:
74: cursor l_rl_csr1( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
75: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
76: chrId NUMBER,
77: cleId NUMBER ) IS
78: select crl.id slh_id,

Line 88: from OKC_RULE_GROUPS_B crg,

84: crl.RULE_INFORMATION6,
85: crl.RULE_INFORMATION7,
86: crl.RULE_INFORMATION8,
87: crl.RULE_INFORMATION10
88: from OKC_RULE_GROUPS_B crg,
89: OKC_RULES_B crl
90: where crl.rgp_id = crg.id
91: and crg.RGD_CODE = rgcode
92: and crl.RULE_INFORMATION_CATEGORY = rlcat

Line 97: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

93: and crg.dnz_chr_id = chrId
94: and nvl(crg.cle_id,-1) = cleId
95: order by crl.RULE_INFORMATION1;
96:
97: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
98: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
99: chrId NUMBER) IS
100: select crl.object1_id1,
101: crl.RULE_INFORMATION1,

Line 110: from OKC_RULE_GROUPS_B crg,

106: crl.RULE_INFORMATION6,
107: crl.RULE_INFORMATION7,
108: crl.RULE_INFORMATION10,
109: crl.RULE_INFORMATION11
110: from OKC_RULE_GROUPS_B crg,
111: OKC_RULES_B crl
112: where crl.rgp_id = crg.id
113: and crg.RGD_CODE = rgcode
114: and crl.RULE_INFORMATION_CATEGORY = rlcat

Line 130: from OKC_RULE_GROUPS_B crg,

126: crl.RULE_INFORMATION6,
127: crl.RULE_INFORMATION7,
128: crl.RULE_INFORMATION10,
129: crl.RULE_INFORMATION11
130: from OKC_RULE_GROUPS_B crg,
131: OKC_RULES_B crl
132: where crl.rgp_id = crg.id
133: and crl.RULE_INFORMATION_CATEGORY = rlcat
134: and crg.dnz_chr_id = chrId

Line 314: from OKC_RULE_GROUPS_B crg,

310:
311:
312: Cursor l_struct_csr( chrId NUMBER ) is
313: select distinct(nvl(crl.RULE_INFORMATION5,-1)) structure
314: from OKC_RULE_GROUPS_B crg,
315: OKC_RULES_B crl
316: where crl.rgp_id = crg.id
317: and crg.RGD_CODE = 'LALEVL'
318: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'