APPS.OKL_PROCESS_STREAMS_PVT dependencies on OKC_RULE_GROUPS_B

Line 151: OKC_RULE_GROUPS_B CRGB,

147: CRGB.ID RULE_GROUP_ID,
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

Line 165: cursor rules_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

161: AND KLIN.ID = p_kle_id
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: )

Line 180: FROM OKC_RULE_GROUPS_B CRGB,

176: CRLB.RULE_INFORMATION5,
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

Line 382: OKC_RULE_GROUPS_B CRGB,

378: CRGB.ID RULE_GROUP_ID,
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

Line 397: cursor rules_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

393: AND KLIN.LSE_ID = LSTL.ID
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: )

Line 412: FROM OKC_RULE_GROUPS_B CRGB,

408: CRLB.RULE_INFORMATION3,
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

Line 2740: FROM okc_rule_groups_b crg,

2736: p_date DATE,
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'

Line 2757: FROM okc_rule_groups_b crg,

2753: CURSOR get_slh_csr(p_chr_id NUMBER,
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'

Line 2771: FROM okc_rule_groups_b crg,

2767: p_cle_id NUMBER,
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'

Line 3221: FROM okc_rule_groups_b crg,

3217: p_date DATE,
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'

Line 3236: FROM okc_rule_groups_b crg,

3232: CURSOR get_slh_csr(p_chr_id NUMBER,
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'

Line 3250: FROM okc_rule_groups_b crg,

3246: p_cle_id NUMBER,
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'