APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_RULES_B

Line 52: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
56: crl.object1_id1,

Line 65: OKC_RULES_B crl

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
69: and crl.RULE_INFORMATION_CATEGORY = rlcat

Line 75: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
79: crl.object1_id1,

Line 89: OKC_RULES_B crl

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
93: and crg.dnz_chr_id = chrId

Line 100: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

96:
97: --Bug# 8652738
98: -- Modified cursor to only fetch contract header level rules
99: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
100: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
101: chrId NUMBER) IS
102: select crl.object1_id1,
103: crl.RULE_INFORMATION1,
104: crl.RULE_INFORMATION2,

Line 113: OKC_RULES_B crl

109: crl.RULE_INFORMATION7,
110: crl.RULE_INFORMATION10,
111: crl.RULE_INFORMATION11
112: from OKC_RULE_GROUPS_B crg,
113: OKC_RULES_B crl
114: where crl.rgp_id = crg.id
115: and crg.RGD_CODE = rgcode
116: and crl.RULE_INFORMATION_CATEGORY = rlcat
117: and crg.chr_id = chrId;

Line 119: cursor l_oksrl_csr(rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

115: and crg.RGD_CODE = rgcode
116: and crl.RULE_INFORMATION_CATEGORY = rlcat
117: and crg.chr_id = chrId;
118:
119: cursor l_oksrl_csr(rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
120: chrId NUMBER,
121: cleId NUMBER) IS
122: select crl.object1_id1,
123: crl.RULE_INFORMATION1,

Line 133: OKC_RULES_B crl

129: crl.RULE_INFORMATION7,
130: crl.RULE_INFORMATION10,
131: crl.RULE_INFORMATION11
132: from OKC_RULE_GROUPS_B crg,
133: OKC_RULES_B crl
134: where crl.rgp_id = crg.id
135: and crl.RULE_INFORMATION_CATEGORY = rlcat
136: and crg.dnz_chr_id = chrId
137: and nvl(crg.cle_id, -1) = cleId;

Line 317: OKC_RULES_B crl

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

Line 439: okc_rules_b rulb,

435: rulb2.rule_information7 stub_days,rulb2.rule_information8 stub_amount,
436: rulb2.rule_information10 arrear_yn
437: FROM okc_k_lines_b cleb,
438: okc_rule_groups_b rgpb,
439: okc_rules_b rulb,
440: okc_rules_b rulb2,
441: okl_strm_type_b styb,
442: okl_strm_type_tl tl
443: WHERE rgpb.chr_id IS NULL

Line 440: okc_rules_b rulb2,

436: rulb2.rule_information10 arrear_yn
437: FROM okc_k_lines_b cleb,
438: okc_rule_groups_b rgpb,
439: okc_rules_b rulb,
440: okc_rules_b rulb2,
441: okl_strm_type_b styb,
442: okl_strm_type_tl tl
443: WHERE rgpb.chr_id IS NULL
444: AND rgpb.dnz_chr_id = cleb.dnz_chr_id