eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKC_RULES_B

Line 184: okc_rules_b slh,

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'
188: AND slh.rgp_id = rg.id

Line 185: okc_rules_b sll,

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'
188: AND slh.rgp_id = rg.id
189: AND sll.object2_id1 = to_char(slh.id)

Line 1520: OKC_RULES_B SLH,

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'
1524: AND slh.rgp_id = rg.id

Line 1521: OKC_RULES_B SLL,

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'
1524: AND slh.rgp_id = rg.id
1525: AND sll.object2_id1 = to_char(slh.id)

Line 3383: rlcat okc_rules_b.rule_information_category%TYPE,

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
3387: SELECT crl.id slh_id,

Line 3390: okc_rules_b crl

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
3394: AND crg.dnz_chr_id = chrId

Line 3399: rlcat okc_rules_b.rule_information_category%TYPE,

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
3403: SELECT crl.id slh_id,

Line 3415: okc_rules_b crl

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
3419: AND crg.dnz_chr_id = chrId

Line 4178: OKC_RULES_B SLH,

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'
4182: AND slh.rgp_id = rg.id

Line 4179: OKC_RULES_B SLL,

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'
4182: AND slh.rgp_id = rg.id
4183: AND sll.object2_id1 = TO_CHAR(slh.id)