DBA Data[Home] [Help]

APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKC_RULES_V

Line 1150: okc_rules_v rl

1146: CURSOR c_get_rent_slh_id(c_line_id NUMBER,c_khr_id NUMBER)
1147: IS
1148: select rl.id
1149: from okc_rule_groups_v rg,
1150: okc_rules_v rl
1151: where rl.rgp_id = rg.id
1152: and rl.dnz_chr_id = rg.dnz_chr_id
1153: and rg.cle_id = c_line_id
1154: and rg.rgd_code = 'LALEVL'

Line 1164: okc_rules_v rl

1160: IS
1161: select rl.object1_id1 frequency
1162: ,nvl(rl.rule_information10,'N') Arrears
1163: from okc_rule_groups_v rg,
1164: okc_rules_v rl
1165: where rl.rgp_id = rg.id
1166: and rl.dnz_chr_id = rg.dnz_chr_id
1167: and rg.cle_id = c_line_id
1168: and rg.rgd_code = 'LALEVL'