APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKC_RULE_GROUPS_B

Line 181: okc_rule_groups_b rg,

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

Line 1054: OKC_RULE_GROUPS_B RG,

1050: IS
1051: SELECT decode(sll.rule_information10, NULL, 'N', 'Y', 'Y', 'N') arrears_yn,
1052: decode(sll.object1_id1, 'A',12,'S',6,'Q',3,'M',1) frequency
1053: FROM OKC_K_HEADERS_B K,
1054: OKC_RULE_GROUPS_B RG,
1055: OKC_RULES_B SLH,
1056: OKC_RULES_B SLL,
1057: OKL_STRM_TYPE_B STRM
1058: WHERE slh.rule_information_category = 'LASLH'

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

2213: AND str.kle_id = kleid
2214: AND sty.id = styid
2215: AND ste.stream_element_date <= tadate;
2216:
2217: CURSOR l_pmt_sty_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
2218: rlcat okc_rules_b.rule_information_category%TYPE,
2219: chrId NUMBER,
2220: cleId NUMBER)
2221: IS

Line 2224: FROM okc_rule_groups_b crg,

2220: cleId NUMBER)
2221: IS
2222: SELECT crl.id slh_id,
2223: crl.object1_id1
2224: FROM okc_rule_groups_b crg,
2225: okc_rules_b crl
2226: WHERE crl.rgp_id = crg.id
2227: AND crg.rgd_code = rgcode
2228: AND crl.rule_information_category = rlcat

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

2229: AND crg.dnz_chr_id = chrId
2230: AND crg.cle_id = cleId
2231: ORDER BY crl.rule_information1;
2232:
2233: CURSOR l_rl_csr2(rgcode okc_rule_groups_b.rgd_code%TYPE,
2234: rlcat okc_rules_b.rule_information_category%TYPE,
2235: chrId NUMBER,
2236: cleId NUMBER)
2237: IS

Line 2249: FROM okc_rule_groups_b crg,

2245: crl.rule_information7,
2246: crl.rule_information8,
2247: crl.rule_information13,
2248: crl.rule_information10
2249: FROM okc_rule_groups_b crg,
2250: okc_rules_b crl
2251: WHERE crl.rgp_id = crg.id
2252: AND crg.rgd_code = rgcode
2253: AND crl.rule_information_category = rlcat