APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKC_RULE_GROUPS_B

Line 183: okc_rule_groups_b rg,

179: IS
180: SELECT DECODE(sll.rule_information10, NULL, 'N', 'Y', 'Y', 'N') arrears_yn,
181: DECODE(sll.object1_id1, 'A',12,'S',6,'Q',3,'M',1) frequency
182: FROM okc_k_headers_b k,
183: okc_rule_groups_b rg,
184: okc_rules_b slh,
185: okc_rules_b sll,
186: okl_strm_type_b strm
187: WHERE slh.rule_information_category = 'LASLH'

Line 1519: OKC_RULE_GROUPS_B RG,

1515: IS
1516: SELECT decode(sll.rule_information10, NULL, 'N', 'Y', 'Y', 'N') arrears_yn,
1517: decode(sll.object1_id1, 'A',12,'S',6,'Q',3,'M',1) frequency
1518: FROM OKC_K_HEADERS_B K,
1519: OKC_RULE_GROUPS_B RG,
1520: OKC_RULES_B SLH,
1521: OKC_RULES_B SLL,
1522: OKL_STRM_TYPE_B STRM
1523: WHERE slh.rule_information_category = 'LASLH'

Line 3382: CURSOR l_pmt_sty_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,

3378: AND str.kle_id = kleid
3379: AND sty.id = styid
3380: AND ste.stream_element_date <= tadate;
3381:
3382: CURSOR l_pmt_sty_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
3383: rlcat okc_rules_b.rule_information_category%TYPE,
3384: chrId NUMBER,
3385: cleId NUMBER)
3386: IS

Line 3389: FROM okc_rule_groups_b crg,

3385: cleId NUMBER)
3386: IS
3387: SELECT crl.id slh_id,
3388: crl.object1_id1
3389: FROM okc_rule_groups_b crg,
3390: okc_rules_b crl
3391: WHERE crl.rgp_id = crg.id
3392: AND crg.rgd_code = rgcode
3393: AND crl.rule_information_category = rlcat

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

3394: AND crg.dnz_chr_id = chrId
3395: AND crg.cle_id = cleId
3396: ORDER BY crl.rule_information1;
3397:
3398: CURSOR l_rl_csr2(rgcode okc_rule_groups_b.rgd_code%TYPE,
3399: rlcat okc_rules_b.rule_information_category%TYPE,
3400: chrId NUMBER,
3401: cleId NUMBER)
3402: IS

Line 3414: FROM okc_rule_groups_b crg,

3410: crl.rule_information7,
3411: crl.rule_information8,
3412: crl.rule_information13,
3413: crl.rule_information10
3414: FROM okc_rule_groups_b crg,
3415: okc_rules_b crl
3416: WHERE crl.rgp_id = crg.id
3417: AND crg.rgd_code = rgcode
3418: AND crl.rule_information_category = rlcat

Line 4177: OKC_RULE_GROUPS_B RG,

4173: IS
4174: SELECT DECODE(sll.rule_information10, NULL, 'N', 'Y', 'Y', 'N') arrears_yn,
4175: DECODE(sll.object1_id1, 'A',12,'S',6,'Q',3,'M',1) frequency
4176: FROM OKC_K_HEADERS_B K,
4177: OKC_RULE_GROUPS_B RG,
4178: OKC_RULES_B SLH,
4179: OKC_RULES_B SLL,
4180: OKL_STRM_TYPE_B STRM
4181: WHERE slh.rule_information_category = 'LASLH'