DBA Data[Home] [Help]

APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKC_RULE_GROUPS_V

Line 1149: from okc_rule_groups_v rg,

1145:
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

Line 1163: from okc_rule_groups_v rg,

1159: CURSOR c_get_freq_arr(c_line_id NUMBER,c_khr_id NUMBER,c_rent_slh_id NUMBER)
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