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 99: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

95: order by crl.RULE_INFORMATION1;
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,

Line 112: from OKC_RULE_GROUPS_B crg,

108: crl.RULE_INFORMATION6,
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

Line 132: from OKC_RULE_GROUPS_B crg,

128: crl.RULE_INFORMATION6,
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

Line 316: from OKC_RULE_GROUPS_B crg,

312:
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'

Line 438: okc_rule_groups_b rgpb,

434: rulb2.rule_information2 start_date,rulb2.rule_information3 level_periods,
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