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 7217: FROM okl_time_units_v tuom,

7213: sll_rul.rule_information10 due_arrears_yn,
7214: sll_rul.rule_information7 stub_days,
7215: sll_rul.rule_information8 stub_amount,
7216: rgp.dnz_chr_id khr_id
7217: FROM okl_time_units_v tuom,
7218: okc_rules_b sll_rul,
7219: okl_strmtyp_source_v sttyp,
7220: okc_rules_b slh_rul,
7221: okc_rule_groups_b rgp

Line 7236: FROM okl_time_units_v tuom,

7232:
7233: CURSOR c_unscheduled_count(p_contract_id IN NUMBER,
7234: p_sty_id IN NUMBER) IS
7235: SELECT COUNT(*)
7236: FROM okl_time_units_v tuom,
7237: okc_rules_b sll_rul,
7238: okl_strmtyp_source_v sttyp,
7239: okc_rules_b slh_rul,
7240: okc_rule_groups_b rgp

Line 7255: FROM okl_time_units_v tuom,

7251:
7252: CURSOR c_max_date(p_contract_id IN NUMBER,
7253: p_sty_id IN NUMBER) IS
7254: SELECT max(to_date(sll_rul.rule_information2,'YYYY/MM/DD HH24:MI:SS')) start_date
7255: FROM okl_time_units_v tuom,
7256: okc_rules_b sll_rul,
7257: okl_strmtyp_source_v sttyp,
7258: okc_rules_b slh_rul,
7259: okc_rule_groups_b rgp