APPS.OKL_LA_STREAM_PVT dependencies on OKC_RULE_GROUPS_B

Line 145: CURSOR l_hdrrl_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,

141: SELECT lsm.id
142: FROM okl_streams lsm
143: WHERE lsm.khr_id = khrid;
144: -- get the Header rule information
145: CURSOR l_hdrrl_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
146: rlcat okc_rules_b.rule_information_category%TYPE,
147: chrId NUMBER)
148: IS
149: SELECT crl.object1_id1,

Line 159: FROM okc_rule_groups_b crg,

155: crl.rule_information6,
156: crl.rule_information10,
157: crl.rule_information13,
158: crl.rule_information11
159: FROM okc_rule_groups_b crg,
160: okc_rules_b crl
161: WHERE crl.rgp_id = crg.id
162: AND crg.rgd_code = rgcode
163: AND crl.rule_information_category = rlcat

Line 167: rgcode okc_rule_groups_b.rgd_code%TYPE,

163: AND crl.rule_information_category = rlcat
164: AND crg.dnz_chr_id = chrId;
165: -- get the self referencing Line based rule information
166: CURSOR l_rl_csr(rlgpId NUMBER,
167: rgcode okc_rule_groups_b.rgd_code%TYPE,
168: rlcat okc_rules_b.rule_information_category%TYPE,
169: chrId NUMBER,
170: cleId NUMBER )
171: IS

Line 185: FROM okc_rule_groups_b crg,

181: --end bug#2757289 bakuchib
182: crl.rule_information13,
183: crl.rule_information10,
184: DECODE(crl.object1_id1,'M',1,'Q',3,'S',6,'A',12) decoded_object1_id1
185: FROM okc_rule_groups_b crg,
186: okc_rules_b crl
187: WHERE crl.rgp_id = crg.id
188: AND crl.object2_id1 = rlgpId
189: AND crg.rgd_code = rgcode

Line 198: CURSOR l_rl_csr2(rgcode okc_rule_groups_b.rgd_code%TYPE,

194: --start bug#2757289 bakuchib
195: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
196: --end bug#2757289 bakuchib
197: -- get the Line rule information
198: CURSOR l_rl_csr2(rgcode okc_rule_groups_b.rgd_code%TYPE,
199: rlcat okc_rules_b.rule_information_category%TYPE,
200: chrId NUMBER,
201: cleId NUMBER)
202: IS

Line 216: FROM okc_rule_groups_b crg,

212: crl.rule_information8,
213: crl.rule_information13,
214: --end bug#2757289 bakuchib
215: crl.rule_information10
216: FROM okc_rule_groups_b crg,
217: okc_rules_b crl
218: WHERE crl.rgp_id = crg.id
219: AND crg.rgd_code = rgcode
220: AND crl.rule_information_category = rlcat

Line 225: CURSOR l_rl_csr1(rgcode okc_rule_groups_b.rgd_code%TYPE,

221: AND crg.dnz_chr_id = chrId
222: AND crg.cle_id = cleId
223: ORDER BY crl.rule_information1;
224: -- get the Line rule information
225: CURSOR l_rl_csr1(rgcode okc_rule_groups_b.rgd_code%TYPE,
226: rlcat okc_rules_b.rule_information_category%TYPE,
227: chrId NUMBER,
228: cleId NUMBER )
229: IS

Line 243: FROM okc_rule_groups_b crg,

239: crl.rule_information8,
240: crl.rule_information13,
241: --end bug#2757289 bakuchib
242: crl.rule_information10
243: FROM okc_rule_groups_b crg,
244: okc_rules_b crl
245: WHERE crl.rgp_id = crg.id
246: AND crg.rgd_code = rgcode
247: AND crl.rule_information_category = rlcat