[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
250: ,0 interest
251: ,decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
252: FROM okl_strm_elements sel,
253: okl_streams stm,
254: okl_strm_type_b sty
255: WHERE stm.khr_id = cp_khr_id
256: AND sty.id = stm.sty_id
257: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
258: AND sel.stm_id = stm.id
265: ,sel.amount interest
266: ,decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
267: FROM okl_strm_elements sel,
268: okl_streams stm,
269: okl_strm_type_b sty
270: WHERE stm.khr_id = cp_khr_id
271: AND sty.id = stm.sty_id
272: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
273: AND sel.stm_id = stm.id
290: sel.amount princ_pay_down,
291: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
292: FROM okl_strm_elements sel,
293: okl_streams stm,
294: okl_strm_type_b sty
295: WHERE stm.khr_id = cp_khr_id
296: AND sty.id = stm.sty_id
297: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
298: AND sel.stm_id = stm.id
504: ,sel.amount principal
505: ,0 interest
506: FROM okl_strm_elements sel,
507: okl_streams stm,
508: okl_strm_type_b sty
509: WHERE stm.khr_id = cp_khr_id
510: AND sty.id = stm.sty_id
511: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
512: AND sel.stm_id = stm.id
518: ,0 principal
519: ,sel.amount interest
520: FROM okl_strm_elements sel,
521: okl_streams stm,
522: okl_strm_type_b sty
523: WHERE stm.khr_id = cp_khr_id
524: AND sty.id = stm.sty_id
525: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
526: AND sel.stm_id = stm.id
537: SELECT sel.stream_element_date bill_date
538: ,sum(sel.amount) ppd_amount
539: FROM okl_strm_elements sel,
540: okl_streams stm,
541: okl_strm_type_b sty
542: WHERE stm.khr_id = cp_khr_id
543: AND sty.id = stm.sty_id
544: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
545: AND sel.stm_id = stm.id
775: sel_dii.amount interest,
776: sel_dii.request_id
777: FROM okl_strm_elements sel_dii,
778: okl_streams stm_dii,
779: okl_strm_type_b sty_dii
780: WHERE stm_dii.khr_id = p_chr_id
781: AND sty_dii.id = stm_dii.sty_id
782: AND sty_dii.stream_type_purpose = 'DAILY_INTEREST_INTEREST'
783: AND sel_dii.stm_id = stm_dii.id
789: 0 interest,
790: sel_dip.request_id
791: FROM okl_strm_elements sel_dip,
792: okl_streams stm_dip,
793: okl_strm_type_b sty_dip
794: WHERE stm_dip.khr_id = p_chr_id
795: AND sty_dip.id = stm_dip.sty_id
796: AND sty_dip.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
797: AND sel_dip.stm_id = stm_dip.id
997: 0 principal,
998: sel_dii.amount interest
999: FROM okl_strm_elements sel_dii,
1000: okl_streams stm_dii,
1001: okl_strm_type_b sty_dii
1002: WHERE stm_dii.khr_id = p_chr_id
1003: AND sty_dii.id = stm_dii.sty_id
1004: AND sty_dii.stream_type_purpose = 'DAILY_INTEREST_INTEREST'
1005: AND sel_dii.stm_id = stm_dii.id
1010: sel_dip.amount principal,
1011: 0 interest
1012: FROM okl_strm_elements sel_dip,
1013: okl_streams stm_dip,
1014: okl_strm_type_b sty_dip
1015: WHERE stm_dip.khr_id = p_chr_id
1016: AND sty_dip.id = stm_dip.sty_id
1017: AND sty_dip.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
1018: AND sel_dip.stm_id = stm_dip.id
1338: CURSOR last_bill_date_csr(p_chr_id IN NUMBER) IS
1339: SELECT MAX(sel.stream_element_date)
1340: FROM okl_streams stm,
1341: okl_strm_elements sel,
1342: okl_strm_type_b sty
1343: WHERE stm.khr_id = p_chr_id
1344: AND sty.id = stm.sty_id
1345: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
1346: AND sel.stm_id = stm.id
1369: sel.amount interest,
1370: G_BILLED payment_type
1371: FROM okl_strm_elements sel,
1372: okl_streams stm,
1373: okl_strm_type_b sty
1374: WHERE stm.khr_id = p_chr_id
1375: AND sty.id = stm.sty_id
1376: AND sty.stream_type_purpose = 'VARIABLE_INTEREST'
1377: AND sel.stm_id = stm.id
1384: 0 interest,
1385: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1386: FROM okl_strm_elements sel,
1387: okl_streams stm,
1388: okl_strm_type_b sty
1389: WHERE stm.khr_id = p_chr_id
1390: AND sty.id = stm.sty_id
1391: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
1392: AND sel.stm_id = stm.id
1398: sel.amount interest,
1399: G_PROJECTED payment_type
1400: FROM okl_strm_elements sel,
1401: okl_streams stm,
1402: okl_strm_type_b sty
1403: WHERE stm.khr_id = p_chr_id
1404: AND sty.id = stm.sty_id
1405: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
1406: AND sel.stm_id = stm.id
1424: sel.amount princ_pay_down,
1425: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1426: FROM okl_strm_elements sel,
1427: okl_streams stm,
1428: okl_strm_type_b sty
1429: WHERE stm.khr_id = p_chr_id
1430: AND sty.id = stm.sty_id
1431: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
1432: AND sel.stm_id = stm.id
1596: CURSOR last_bill_date_csr(p_chr_id IN NUMBER) IS
1597: SELECT MAX(sel.stream_element_date)
1598: FROM okl_streams stm,
1599: okl_strm_elements sel,
1600: okl_strm_type_b sty
1601: WHERE stm.khr_id = p_chr_id
1602: AND sty.id = stm.sty_id
1603: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
1604: AND sel.stm_id = stm.id
1624: 0 principal,
1625: sel.amount interest
1626: FROM okl_strm_elements sel,
1627: okl_streams stm,
1628: okl_strm_type_b sty
1629: WHERE stm.khr_id = p_chr_id
1630: AND sty.id = stm.sty_id
1631: AND sty.stream_type_purpose = 'VARIABLE_INTEREST'
1632: AND sel.stm_id = stm.id
1638: 0 principal,
1639: sel.amount interest
1640: FROM okl_strm_elements sel,
1641: okl_streams stm,
1642: okl_strm_type_b sty
1643: WHERE stm.khr_id = p_chr_id
1644: AND sty.id = stm.sty_id
1645: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
1646: AND sel.stm_id = stm.id
1653: sel.amount principal,
1654: 0 interest
1655: FROM okl_strm_elements sel,
1656: okl_streams stm,
1657: okl_strm_type_b sty
1658: WHERE stm.khr_id = p_chr_id
1659: AND sty.id = stm.sty_id
1660: AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT','UNSCHEDULED_PRINCIPAL_PAYMENT')
1661: AND sel.stm_id = stm.id
1911: sel.amount interest,
1912: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1913: FROM okl_strm_elements sel,
1914: okl_streams stm,
1915: okl_strm_type_b sty
1916: WHERE stm.khr_id = p_chr_id
1917: AND sty.id = stm.sty_id
1918: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
1919: AND sel.stm_id = stm.id
1925: 0 interest,
1926: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1927: FROM okl_strm_elements sel,
1928: okl_streams stm,
1929: okl_strm_type_b sty
1930: WHERE stm.khr_id = p_chr_id
1931: AND sty.id = stm.sty_id
1932: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
1933: AND sel.stm_id = stm.id
1942: 0 princ_pay_down,
1943: G_BILLED payment_type
1944: FROM okl_strm_elements sel,
1945: okl_streams stm,
1946: okl_strm_type_b sty
1947: WHERE stm.khr_id = p_chr_id
1948: AND sty.id = stm.sty_id
1949: AND sty.stream_type_purpose = 'PRINCIPAL_CATCHUP'
1950: AND sel.stm_id = stm.id
1959: 0 princ_pay_down,
1960: G_BILLED payment_type
1961: FROM okl_strm_elements sel,
1962: okl_streams stm,
1963: okl_strm_type_b sty
1964: WHERE stm.khr_id = p_chr_id
1965: AND sty.id = stm.sty_id
1966: AND sty.stream_type_purpose = 'INTEREST_CATCHUP'
1967: AND sel.stm_id = stm.id
1983: sel.amount princ_pay_down,
1984: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1985: FROM okl_strm_elements sel,
1986: okl_streams stm,
1987: okl_strm_type_b sty
1988: WHERE stm.khr_id = p_chr_id
1989: AND sty.id = stm.sty_id
1990: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
1991: AND sel.stm_id = stm.id
2185: sel.amount interest,
2186: DECODE(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
2187: FROM okl_strm_elements sel,
2188: okl_streams stm,
2189: okl_strm_type_b sty
2190: WHERE stm.khr_id = p_chr_id
2191: AND sty.id = stm.sty_id
2192: AND sty.stream_type_purpose IN ('INTEREST_PAYMENT','INTEREST_CATCHUP')
2193: AND sel.stm_id = stm.id
2199: 0 interest,
2200: DECODE(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
2201: FROM okl_strm_elements sel,
2202: okl_streams stm,
2203: okl_strm_type_b sty
2204: WHERE stm.khr_id = p_chr_id
2205: AND sty.id = stm.sty_id
2206: AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT','PRINCIPAL_CATCHUP','UNSCHEDULED_PRINCIPAL_PAYMENT')
2207: AND sel.stm_id = stm.id
2479: FROM okc_k_lines_b cleb,
2480: okc_rule_groups_b rgpb,
2481: okc_rules_b rulb,
2482: okc_rules_b rulb2,
2483: okl_strm_type_b styb,
2484: okc_statuses_b sts
2485: WHERE rgpb.chr_id IS NULL
2486: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
2487: AND rgpb.cle_id = cleb.id