[Home] [Help]
249: ,sel.amount principal
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'
264: ,0 principal
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'
289: 0 interest,
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'
503: SELECT sel.stream_element_date bill_date
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'
517: SELECT sel.stream_element_date bill_date
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'
536: CURSOR c_amort_sch_ppd_csr(cp_khr_id IN NUMBER) IS
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'
774: 0 principal,
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'
788: sel_dip.amount principal,
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'
996: SELECT sel_dii.stream_element_date receipt_date,
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'
1009: SELECT sel_dip.stream_element_date receipt_date,
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'
1336: l_api_version CONSTANT NUMBER := 1.0;
1337:
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
1368: 0 principal,
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'
1383: sel.amount principal,
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'
1397: 0 principal,
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'
1423: 0 interest,
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'
1594: l_api_version CONSTANT NUMBER := 1.0;
1595:
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
1623: SELECT sel.stream_element_date bill_date,
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'
1637: SELECT sel.stream_element_date bill_date,
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'
1652: SELECT sel.stream_element_date bill_date,
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')
1910: 0 principal,
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'
1924: sel.amount principal,
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'
1941: 0 interest,
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'
1958: SUM(sel.amount) interest,
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'
1982: 0 interest,
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'
2184: 0 principal,
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')
2198: sel.amount principal,
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')