APPS.OKL_CONTRACT_INFO dependencies on OKC_RULE_GROUPS_B

Line 271: FROM okc_rule_groups_b rgp, okc_rules_b rul

267:
268: -- Following cursor introduced for bug: 3838403
269: CURSOR get_non_notify_flag (p_contract_id IN NUMBER) IS
270: SELECT RULE_INFORMATION1
271: FROM okc_rule_groups_b rgp, okc_rules_b rul
272: WHERE rgp.id = rul.rgp_id
273: AND rgp.dnz_chr_id = p_contract_id
274: AND rgp.rgd_code = 'LANNTF'
275: AND rul.rule_information_category = 'LANNTF';

Line 1249: FROM okc_rules_v orv1, okc_rule_groups_b org1

1245:
1246: -- get advanced rent
1247: CURSOR advance_rent_csr IS
1248: SELECT SUM(nvl(orv1.rule_information6,0))
1249: FROM okc_rules_v orv1, okc_rule_groups_b org1
1250: WHERE org1.dnz_chr_id = p_contract_id
1251: AND org1.id = orv1.rgp_id
1252: AND orv1.rule_information_category = 'SLL'
1253: AND EXISTS

Line 1263: FROM okc_rules_v orv1, okc_rule_groups_b org1

1259:
1260: -- get security deposit
1261: CURSOR security_deposit_csr IS
1262: SELECT SUM(nvl(orv1.rule_information6,0))
1263: FROM okc_rules_v orv1, okc_rule_groups_b org1
1264: WHERE org1.dnz_chr_id = p_contract_id
1265: AND org1.id = orv1.rgp_id
1266: AND orv1.rule_information_category = 'SLL'
1267: AND EXISTS

Line 1277: FROM okc_rules_v orv1, okc_rule_groups_b org1

1273:
1274: -- get interest type
1275: CURSOR Interest_type_csr IS
1276: SELECT SUM(nvl(orv1.rule_information6,0))
1277: FROM okc_rules_v orv1, okc_rule_groups_b org1
1278: WHERE org1.dnz_chr_id = p_contract_id
1279: AND org1.id = orv1.rgp_id
1280: AND orv1.rule_information_category = 'SLL'
1281: AND EXISTS