DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKC_RULE_GROUPS_B

Line 1788: okc_rule_groups_b rgp

1784: SELECT DECODE(sll.object1_id1,'M',1,'Q',3,'S',6,'A',12) pay_freq
1785: FROM okc_rules_b sll,
1786: okc_rules_b slh,
1787: okl_strm_type_v styp,
1788: okc_rule_groups_b rgp
1789: WHERE TO_NUMBER(sll.object2_id1) = slh.id
1790: AND sll.rule_information_category = 'LASLL'
1791: AND sll.dnz_chr_id = rgp.dnz_chr_id
1792: AND sll.rgp_id = rgp.id

Line 1830: FROM okc_rule_groups_b rgp,

1826:
1827: --Bug# 14049528
1828: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
1829: SELECT NVL(rul2.rule_information10,'N') arrears_yn
1830: FROM okc_rule_groups_b rgp,
1831: okc_rules_b rul1,
1832: okc_rules_b rul2,
1833: okl_strm_type_b sty
1834: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id