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_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKC_RULES_B

Line 624: from okc_rules_b

620: id = p_khr_id;
621:
622: CURSOR c_fact IS
623: select '1'
624: from okc_rules_b
625: where dnz_chr_id = p_khr_id
626: and rule_information_category = 'LAFCTG'
627: and (rule_information1 is not null
628: or rule_information2 is not null

Line 1221: FROM okc_rules_b sll_rul,

1217: --Get type of Stream type , Principal Payment Stream type or Rent Stream type
1218: CURSOR l_stream_type_csr(p_stream_type IN VARCHAR2
1219: ,p_khr_id IN NUMBER) IS
1220: SELECT COUNT(*)
1221: FROM okc_rules_b sll_rul,
1222: okl_strmtyp_source_v sttyp,
1223: okc_rules_b slh_rul,
1224: okc_rule_groups_b rgp
1225: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)

Line 1223: okc_rules_b slh_rul,

1219: ,p_khr_id IN NUMBER) IS
1220: SELECT COUNT(*)
1221: FROM okc_rules_b sll_rul,
1222: okl_strmtyp_source_v sttyp,
1223: okc_rules_b slh_rul,
1224: okc_rule_groups_b rgp
1225: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)
1226: AND sll_rul.rgp_id = rgp.id
1227: AND sll_rul.rule_information_category = 'LASLL'

Line 1263: okc_rules_b sll_rul,

1259: sll_rul.rule_information7 stub_days,
1260: sll_rul.rule_information8 stub_amount,
1261: rgp.dnz_chr_id khr_id
1262: FROM okl_time_units_v tuom,
1263: okc_rules_b sll_rul,
1264: okl_strmtyp_source_v sttyp,
1265: okc_rules_b slh_rul,
1266: okc_rule_groups_b rgp
1267: WHERE tuom.id1 = sll_rul.object1_id1

Line 1265: okc_rules_b slh_rul,

1261: rgp.dnz_chr_id khr_id
1262: FROM okl_time_units_v tuom,
1263: okc_rules_b sll_rul,
1264: okl_strmtyp_source_v sttyp,
1265: okc_rules_b slh_rul,
1266: okc_rule_groups_b rgp
1267: WHERE tuom.id1 = sll_rul.object1_id1
1268: AND sll_rul.object2_id1 = to_char(slh_rul.id)
1269: AND sll_rul.rgp_id = rgp.id

Line 2470: FROM okc_rules_b sll_rul,

2466: CURSOR c_get_total_ppd (c_cle_id NUMBER
2467: ,c_sty_id NUMBER)
2468: IS
2469: SELECT sum(sll_rul.rule_information8)
2470: FROM okc_rules_b sll_rul,
2471: okl_strmtyp_source_v sttyp,
2472: okc_rules_b slh_rul,
2473: okc_rule_groups_b rgp
2474: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)

Line 2472: okc_rules_b slh_rul,

2468: IS
2469: SELECT sum(sll_rul.rule_information8)
2470: FROM okc_rules_b sll_rul,
2471: okl_strmtyp_source_v sttyp,
2472: okc_rules_b slh_rul,
2473: okc_rule_groups_b rgp
2474: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)
2475: AND sll_rul.rgp_id = rgp.id
2476: AND sll_rul.rule_information_category = 'LASLL'

Line 4696: FROM okc_rules_b sll_rul,

4692: --Bug#5100215 added cursor start --dkagrawa
4693: CURSOR l_stream_type_csr(p_stream_type IN VARCHAR2
4694: ,p_khr_id IN NUMBER) IS
4695: SELECT COUNT(*)
4696: FROM okc_rules_b sll_rul,
4697: okl_strmtyp_source_v sttyp,
4698: okc_rules_b slh_rul,
4699: okc_rule_groups_b rgp
4700: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)

Line 4698: okc_rules_b slh_rul,

4694: ,p_khr_id IN NUMBER) IS
4695: SELECT COUNT(*)
4696: FROM okc_rules_b sll_rul,
4697: okl_strmtyp_source_v sttyp,
4698: okc_rules_b slh_rul,
4699: okc_rule_groups_b rgp
4700: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)
4701: AND sll_rul.rgp_id = rgp.id
4702: AND sll_rul.rule_information_category = 'LASLL'

Line 7202: okc_rules_b sll_rul,

7198: sll_rul.rule_information7 stub_days,
7199: sll_rul.rule_information8 stub_amount,
7200: rgp.dnz_chr_id khr_id
7201: FROM okl_time_units_v tuom,
7202: okc_rules_b sll_rul,
7203: okl_strmtyp_source_v sttyp,
7204: okc_rules_b slh_rul,
7205: okc_rule_groups_b rgp
7206: WHERE tuom.id1 = sll_rul.object1_id1

Line 7204: okc_rules_b slh_rul,

7200: rgp.dnz_chr_id khr_id
7201: FROM okl_time_units_v tuom,
7202: okc_rules_b sll_rul,
7203: okl_strmtyp_source_v sttyp,
7204: okc_rules_b slh_rul,
7205: okc_rule_groups_b rgp
7206: WHERE tuom.id1 = sll_rul.object1_id1
7207: AND sll_rul.object2_id1 = to_char(slh_rul.id)
7208: AND sll_rul.rgp_id = rgp.id

Line 7221: okc_rules_b sll_rul,

7217: CURSOR c_unscheduled_count(p_contract_id IN NUMBER,
7218: p_sty_id IN NUMBER) IS
7219: SELECT COUNT(*)
7220: FROM okl_time_units_v tuom,
7221: okc_rules_b sll_rul,
7222: okl_strmtyp_source_v sttyp,
7223: okc_rules_b slh_rul,
7224: okc_rule_groups_b rgp
7225: WHERE tuom.id1 = sll_rul.object1_id1

Line 7223: okc_rules_b slh_rul,

7219: SELECT COUNT(*)
7220: FROM okl_time_units_v tuom,
7221: okc_rules_b sll_rul,
7222: okl_strmtyp_source_v sttyp,
7223: okc_rules_b slh_rul,
7224: okc_rule_groups_b rgp
7225: WHERE tuom.id1 = sll_rul.object1_id1
7226: AND sll_rul.object2_id1 = to_char(slh_rul.id)
7227: AND sll_rul.rgp_id = rgp.id

Line 7240: okc_rules_b sll_rul,

7236: CURSOR c_max_date(p_contract_id IN NUMBER,
7237: p_sty_id IN NUMBER) IS
7238: SELECT max(to_date(sll_rul.rule_information2,'YYYY/MM/DD HH24:MI:SS')) start_date
7239: FROM okl_time_units_v tuom,
7240: okc_rules_b sll_rul,
7241: okl_strmtyp_source_v sttyp,
7242: okc_rules_b slh_rul,
7243: okc_rule_groups_b rgp
7244: WHERE tuom.id1 = sll_rul.object1_id1

Line 7242: okc_rules_b slh_rul,

7238: SELECT max(to_date(sll_rul.rule_information2,'YYYY/MM/DD HH24:MI:SS')) start_date
7239: FROM okl_time_units_v tuom,
7240: okc_rules_b sll_rul,
7241: okl_strmtyp_source_v sttyp,
7242: okc_rules_b slh_rul,
7243: okc_rule_groups_b rgp
7244: WHERE tuom.id1 = sll_rul.object1_id1
7245: AND sll_rul.object2_id1 = to_char(slh_rul.id)
7246: AND sll_rul.rgp_id = rgp.id