APPS.OKL_PROCESS_STREAMS_PVT dependencies on OKC_RULES_B

Line 152: OKC_RULES_B CRLB,

148: CRLB.ID SLH_ID
149: FROM
150: OKC_K_HEADERS_B KHRB,
151: OKC_RULE_GROUPS_B CRGB,
152: OKC_RULES_B CRLB,
153: OKC_K_LINES_V KLIN,
154: OKL_STRM_TYPE_B STYB
155: WHERE
156: KHRB.ID = p_khr_id

Line 166: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

162: AND CRGB.CLE_ID = KLIN.ID
163: AND STYB.CODE = 'SECURITY DEPOSIT'
164: AND STYB.ID = CRLB.OBJECT1_ID1;
165: cursor rules_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
166: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
167: chrId NUMBER,
168: slh_id NUMBER
169: )
170: IS

Line 181: OKC_RULES_B CRLB

177:
178: CRLB.RULE_INFORMATION6,
179: CRLB.RULE_INFORMATION10
180: FROM OKC_RULE_GROUPS_B CRGB,
181: OKC_RULES_B CRLB
182: WHERE CRGB.ID = slh_id
183: AND CRLB.RGP_ID = CRGB.ID
184: AND CRGB.RGD_CODE = RGCODE
185: AND CRLB.RULE_INFORMATION_CATEGORY = RLCAT

Line 383: OKC_RULES_B CRLB,

379: CRLB.ID SLH_ID
380: FROM
381: OKC_K_HEADERS_B KHRB,
382: OKC_RULE_GROUPS_B CRGB,
383: OKC_RULES_B CRLB,
384: OKC_K_LINES_V KLIN,
385: OKC_LINE_STYLES_V LSTL
386: WHERE
387: KHRB.ID = p_khr_id

Line 398: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

394: AND LSTL.LTY_CODE = 'SOLD_SERVICE'
395: --smahapat 03/04/03 bug 2823581
396: AND KLIN.STS_CODE IN ('PASSED','COMPLETE');
397: cursor rules_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
398: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
399: chrId NUMBER,
400: slh_id NUMBER
401: )
402: IS

Line 413: OKC_RULES_B CRLB

409: CRLB.RULE_INFORMATION5,
410: CRLB.RULE_INFORMATION6,
411: CRLB.RULE_INFORMATION10
412: FROM OKC_RULE_GROUPS_B CRGB,
413: OKC_RULES_B CRLB
414: WHERE CRGB.ID = slh_id
415: AND CRLB.RGP_ID = CRGB.ID
416: AND CRGB.RGD_CODE = RGCODE
417: AND CRLB.RULE_INFORMATION_CATEGORY = RLCAT

Line 2794: okc_rules_b crl

2790: p_slh_id NUMBER)
2791: IS
2792: SELECT TO_NUMBER(crl.rule_information7) stub_days
2793: FROM okc_rule_groups_b crg,
2794: okc_rules_b crl
2795: WHERE crl.rgp_id = crg.id
2796: AND crl.object2_id1 = p_slh_id
2797: AND crg.rgd_code = 'LALEVL'
2798: AND crl.rule_information_category = 'LASLL'

Line 2811: okc_rules_b crl

2807: p_cle_id NUMBER)
2808: IS
2809: SELECT crl.id slh_id
2810: FROM okc_rule_groups_b crg,
2811: okc_rules_b crl
2812: WHERE crl.rgp_id = crg.id
2813: AND crg.rgd_code = 'LALEVL'
2814: AND crl.rule_information_category = 'LASLH'
2815: AND crg.dnz_chr_id = p_chr_id

Line 2825: okc_rules_b crl

2821: p_slh_id NUMBER)
2822: IS
2823: SELECT crl.object1_id1 frequency
2824: FROM okc_rule_groups_b crg,
2825: okc_rules_b crl
2826: WHERE crl.rgp_id = crg.id
2827: AND crl.object2_id1 = p_slh_id
2828: AND crg.rgd_code = 'LALEVL'
2829: AND crl.rule_information_category = 'LASLL'

Line 3280: okc_rules_b crl

3276: p_slh_id NUMBER)
3277: IS
3278: SELECT TO_NUMBER(crl.rule_information7) stub_days
3279: FROM okc_rule_groups_b crg,
3280: okc_rules_b crl
3281: WHERE crl.rgp_id = crg.id
3282: AND crl.object2_id1 = p_slh_id
3283: AND crg.rgd_code = 'LALEVL'
3284: AND crl.rule_information_category = 'LASLL'

Line 3295: okc_rules_b crl

3291: p_cle_id NUMBER)
3292: IS
3293: SELECT crl.id slh_id
3294: FROM okc_rule_groups_b crg,
3295: okc_rules_b crl
3296: WHERE crl.rgp_id = crg.id
3297: AND crg.rgd_code = 'LALEVL'
3298: AND crl.rule_information_category = 'LASLH'
3299: AND crg.dnz_chr_id = p_chr_id

Line 3309: okc_rules_b crl

3305: p_slh_id NUMBER)
3306: IS
3307: SELECT crl.object1_id1 frequency
3308: FROM okc_rule_groups_b crg,
3309: okc_rules_b crl
3310: WHERE crl.rgp_id = crg.id
3311: AND crl.object2_id1 = p_slh_id
3312: AND crg.rgd_code = 'LALEVL'
3313: AND crl.rule_information_category = 'LASLL'