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 2741: okc_rules_b crl

2737: p_slh_id NUMBER)
2738: IS
2739: SELECT TO_NUMBER(crl.rule_information7) stub_days
2740: FROM okc_rule_groups_b crg,
2741: okc_rules_b crl
2742: WHERE crl.rgp_id = crg.id
2743: AND crl.object2_id1 = p_slh_id
2744: AND crg.rgd_code = 'LALEVL'
2745: AND crl.rule_information_category = 'LASLL'

Line 2758: okc_rules_b crl

2754: p_cle_id NUMBER)
2755: IS
2756: SELECT crl.id slh_id
2757: FROM okc_rule_groups_b crg,
2758: okc_rules_b crl
2759: WHERE crl.rgp_id = crg.id
2760: AND crg.rgd_code = 'LALEVL'
2761: AND crl.rule_information_category = 'LASLH'
2762: AND crg.dnz_chr_id = p_chr_id

Line 2772: okc_rules_b crl

2768: p_slh_id NUMBER)
2769: IS
2770: SELECT crl.object1_id1 frequency
2771: FROM okc_rule_groups_b crg,
2772: okc_rules_b crl
2773: WHERE crl.rgp_id = crg.id
2774: AND crl.object2_id1 = p_slh_id
2775: AND crg.rgd_code = 'LALEVL'
2776: AND crl.rule_information_category = 'LASLL'

Line 3222: okc_rules_b crl

3218: p_slh_id NUMBER)
3219: IS
3220: SELECT TO_NUMBER(crl.rule_information7) stub_days
3221: FROM okc_rule_groups_b crg,
3222: okc_rules_b crl
3223: WHERE crl.rgp_id = crg.id
3224: AND crl.object2_id1 = p_slh_id
3225: AND crg.rgd_code = 'LALEVL'
3226: AND crl.rule_information_category = 'LASLL'

Line 3237: okc_rules_b crl

3233: p_cle_id NUMBER)
3234: IS
3235: SELECT crl.id slh_id
3236: FROM okc_rule_groups_b crg,
3237: okc_rules_b crl
3238: WHERE crl.rgp_id = crg.id
3239: AND crg.rgd_code = 'LALEVL'
3240: AND crl.rule_information_category = 'LASLH'
3241: AND crg.dnz_chr_id = p_chr_id

Line 3251: okc_rules_b crl

3247: p_slh_id NUMBER)
3248: IS
3249: SELECT crl.object1_id1 frequency
3250: FROM okc_rule_groups_b crg,
3251: okc_rules_b crl
3252: WHERE crl.rgp_id = crg.id
3253: AND crl.object2_id1 = p_slh_id
3254: AND crg.rgd_code = 'LALEVL'
3255: AND crl.rule_information_category = 'LASLL'