DBA Data[Home] [Help]

APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_TIME_UNITS_V

Line 1262: FROM okl_time_units_v tuom,

1258: sll_rul.rule_information10 due_arrears_yn,
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

Line 7201: FROM okl_time_units_v tuom,

7197: sll_rul.rule_information10 due_arrears_yn,
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

Line 7220: FROM okl_time_units_v tuom,

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

Line 7239: FROM okl_time_units_v tuom,

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