[Home] [Help]
91: sll.rule_information10 arrears_yn
92: FROM okc_rules_b sll,
93: okc_rules_b slh,
94: okc_rule_groups_b rgp,
95: okl_strm_type_b sty
96: WHERE rgp.dnz_chr_id = p_chr_id
97: AND rgp.cle_id = p_cle_id
98: AND rgp.rgd_code = 'LALEVL'
99: AND slh.rgp_id = rgp.id
251: ,0 interest
252: ,decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
253: FROM okl_strm_elements sel,
254: okl_streams stm,
255: okl_strm_type_b sty,
256: okc_k_lines_b cle
257: WHERE stm.khr_id = cp_khr_id
258: AND sty.id = stm.sty_id
259: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
270: ,sel.amount interest
271: ,decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
272: FROM okl_strm_elements sel,
273: okl_streams stm,
274: okl_strm_type_b sty,
275: okc_k_lines_b cle
276: WHERE stm.khr_id = cp_khr_id
277: AND sty.id = stm.sty_id
278: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
299: sel.amount princ_pay_down,
300: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
301: FROM okl_strm_elements sel,
302: okl_streams stm,
303: okl_strm_type_b sty,
304: okc_k_lines_b cle
305: WHERE stm.khr_id = cp_khr_id
306: AND sty.id = stm.sty_id
307: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
518: ,sel.amount principal
519: ,0 interest
520: FROM okl_strm_elements sel,
521: okl_streams stm,
522: okl_strm_type_b sty,
523: okc_k_lines_b cle
524: WHERE stm.khr_id = cp_khr_id
525: AND sty.id = stm.sty_id
526: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
536: ,0 principal
537: ,sel.amount interest
538: FROM okl_strm_elements sel,
539: okl_streams stm,
540: okl_strm_type_b sty,
541: okc_k_lines_b cle
542: WHERE stm.khr_id = cp_khr_id
543: AND sty.id = stm.sty_id
544: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
559: SELECT sel.stream_element_date bill_date
560: ,sum(sel.amount) ppd_amount
561: FROM okl_strm_elements sel,
562: okl_streams stm,
563: okl_strm_type_b sty,
564: okc_k_lines_b cle
565: WHERE stm.khr_id = cp_khr_id
566: AND sty.id = stm.sty_id
567: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
801: sel_dii.amount interest,
802: sel_dii.request_id
803: FROM okl_strm_elements sel_dii,
804: okl_streams stm_dii,
805: okl_strm_type_b sty_dii
806: WHERE stm_dii.khr_id = p_chr_id
807: AND sty_dii.id = stm_dii.sty_id
808: AND sty_dii.stream_type_purpose = 'DAILY_INTEREST_INTEREST'
809: AND sel_dii.stm_id = stm_dii.id
815: 0 interest,
816: sel_dip.request_id
817: FROM okl_strm_elements sel_dip,
818: okl_streams stm_dip,
819: okl_strm_type_b sty_dip
820: WHERE stm_dip.khr_id = p_chr_id
821: AND sty_dip.id = stm_dip.sty_id
822: AND sty_dip.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
823: AND sel_dip.stm_id = stm_dip.id
1023: 0 principal,
1024: sel_dii.amount interest
1025: FROM okl_strm_elements sel_dii,
1026: okl_streams stm_dii,
1027: okl_strm_type_b sty_dii
1028: WHERE stm_dii.khr_id = p_chr_id
1029: AND sty_dii.id = stm_dii.sty_id
1030: AND sty_dii.stream_type_purpose = 'DAILY_INTEREST_INTEREST'
1031: AND sel_dii.stm_id = stm_dii.id
1036: sel_dip.amount principal,
1037: 0 interest
1038: FROM okl_strm_elements sel_dip,
1039: okl_streams stm_dip,
1040: okl_strm_type_b sty_dip
1041: WHERE stm_dip.khr_id = p_chr_id
1042: AND sty_dip.id = stm_dip.sty_id
1043: AND sty_dip.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
1044: AND sel_dip.stm_id = stm_dip.id
1365: CURSOR last_bill_date_csr(p_chr_id IN NUMBER) IS
1366: SELECT MAX(sel.stream_element_date)
1367: FROM okl_streams stm,
1368: okl_strm_elements sel,
1369: okl_strm_type_b sty,
1370: okc_k_lines_b cle
1371: WHERE stm.khr_id = p_chr_id
1372: AND sty.id = stm.sty_id
1373: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
1401: sel.amount interest,
1402: G_BILLED payment_type
1403: FROM okl_strm_elements sel,
1404: okl_streams stm,
1405: okl_strm_type_b sty,
1406: okc_k_lines_b cle
1407: WHERE stm.khr_id = p_chr_id
1408: AND sty.id = stm.sty_id
1409: AND sty.stream_type_purpose = 'VARIABLE_INTEREST'
1420: 0 interest,
1421: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1422: FROM okl_strm_elements sel,
1423: okl_streams stm,
1424: okl_strm_type_b sty,
1425: okc_k_lines_b cle
1426: WHERE stm.khr_id = p_chr_id
1427: AND sty.id = stm.sty_id
1428: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
1438: sel.amount interest,
1439: G_PROJECTED payment_type
1440: FROM okl_strm_elements sel,
1441: okl_streams stm,
1442: okl_strm_type_b sty,
1443: okc_k_lines_b cle
1444: WHERE stm.khr_id = p_chr_id
1445: AND sty.id = stm.sty_id
1446: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
1468: sel.amount princ_pay_down,
1469: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1470: FROM okl_strm_elements sel,
1471: okl_streams stm,
1472: okl_strm_type_b sty,
1473: okc_k_lines_b cle
1474: WHERE stm.khr_id = p_chr_id
1475: AND sty.id = stm.sty_id
1476: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
1645: CURSOR last_bill_date_csr(p_chr_id IN NUMBER) IS
1646: SELECT MAX(sel.stream_element_date)
1647: FROM okl_streams stm,
1648: okl_strm_elements sel,
1649: okl_strm_type_b sty,
1650: okc_k_lines_b cle
1651: WHERE stm.khr_id = p_chr_id
1652: AND sty.id = stm.sty_id
1653: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
1678: 0 principal,
1679: sel.amount interest
1680: FROM okl_strm_elements sel,
1681: okl_streams stm,
1682: okl_strm_type_b sty,
1683: okc_k_lines_b cle
1684: WHERE stm.khr_id = p_chr_id
1685: AND sty.id = stm.sty_id
1686: AND sty.stream_type_purpose = 'VARIABLE_INTEREST'
1696: 0 principal,
1697: sel.amount interest
1698: FROM okl_strm_elements sel,
1699: okl_streams stm,
1700: okl_strm_type_b sty,
1701: okc_k_lines_b cle
1702: WHERE stm.khr_id = p_chr_id
1703: AND sty.id = stm.sty_id
1704: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
1715: sel.amount principal,
1716: 0 interest
1717: FROM okl_strm_elements sel,
1718: okl_streams stm,
1719: okl_strm_type_b sty,
1720: okc_k_lines_b cle
1721: WHERE stm.khr_id = p_chr_id
1722: AND sty.id = stm.sty_id
1723: AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT','UNSCHEDULED_PRINCIPAL_PAYMENT')
1979: sel.amount interest,
1980: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1981: FROM okl_strm_elements sel,
1982: okl_streams stm,
1983: okl_strm_type_b sty,
1984: okc_k_lines_b cle
1985: WHERE stm.khr_id = p_chr_id
1986: AND sty.id = stm.sty_id
1987: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
1997: 0 interest,
1998: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1999: FROM okl_strm_elements sel,
2000: okl_streams stm,
2001: okl_strm_type_b sty,
2002: okc_k_lines_b cle
2003: WHERE stm.khr_id = p_chr_id
2004: AND sty.id = stm.sty_id
2005: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
2018: 0 princ_pay_down,
2019: G_BILLED payment_type
2020: FROM okl_strm_elements sel,
2021: okl_streams stm,
2022: okl_strm_type_b sty,
2023: okc_k_lines_b cle
2024: WHERE stm.khr_id = p_chr_id
2025: AND sty.id = stm.sty_id
2026: AND sty.stream_type_purpose = 'PRINCIPAL_CATCHUP'
2039: 0 princ_pay_down,
2040: G_BILLED payment_type
2041: FROM okl_strm_elements sel,
2042: okl_streams stm,
2043: okl_strm_type_b sty,
2044: okc_k_lines_b cle
2045: WHERE stm.khr_id = p_chr_id
2046: AND sty.id = stm.sty_id
2047: AND sty.stream_type_purpose = 'INTEREST_CATCHUP'
2067: sel.amount princ_pay_down,
2068: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
2069: FROM okl_strm_elements sel,
2070: okl_streams stm,
2071: okl_strm_type_b sty,
2072: okc_k_lines_b cle
2073: WHERE stm.khr_id = p_chr_id
2074: AND sty.id = stm.sty_id
2075: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
2274: sel.amount interest,
2275: DECODE(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
2276: FROM okl_strm_elements sel,
2277: okl_streams stm,
2278: okl_strm_type_b sty,
2279: okc_k_lines_b cle
2280: WHERE stm.khr_id = p_chr_id
2281: AND sty.id = stm.sty_id
2282: AND sty.stream_type_purpose IN ('INTEREST_PAYMENT','INTEREST_CATCHUP')
2292: 0 interest,
2293: DECODE(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
2294: FROM okl_strm_elements sel,
2295: okl_streams stm,
2296: okl_strm_type_b sty,
2297: okc_k_lines_b cle
2298: WHERE stm.khr_id = p_chr_id
2299: AND sty.id = stm.sty_id
2300: AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT','PRINCIPAL_CATCHUP','UNSCHEDULED_PRINCIPAL_PAYMENT')
2580: FROM okc_k_lines_b cleb,
2581: okc_rule_groups_b rgpb,
2582: okc_rules_b rulb,
2583: okc_rules_b rulb2,
2584: okl_strm_type_b styb,
2585: okc_statuses_b sts
2586: WHERE rgpb.chr_id IS NULL
2587: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
2588: AND rgpb.cle_id = cleb.id