APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_STRM_ELEMENTS

Line 890: FROM okl_strm_elements sele,

886:
887: CURSOR c_payments_made(c_khr_id NUMBER)
888: IS
889: SELECT count(sele.amount)
890: FROM okl_strm_elements sele,
891: okl_streams str,
892: okl_strm_type_v sty
893: WHERE sele.stm_id = str.id
894: AND str.sty_id = sty.id

Line 907: FROM okl_strm_elements sele,

903:
904: CURSOR c_initial_principal(c_khr_id NUMBER)
905: IS
906: SELECT sum(sele.amount)
907: FROM okl_strm_elements sele,
908: okl_streams str,
909: okl_strm_type_v sty
910: WHERE sele.stm_id = str.id
911: AND str.sty_id = sty.id

Line 920: FROM okl_strm_elements sele,

916: AND str.PURPOSE_CODE is NULL
917: --end multigaap changes
918: AND str.khr_id = c_khr_id
919: and sele.stream_element_date = (select min(sele.stream_element_date)
920: FROM okl_strm_elements sele,
921: okl_streams str,
922: okl_strm_type_v sty
923: WHERE sele.stm_id = str.id
924: AND str.sty_id = sty.id

Line 937: FROM okl_strm_elements sele,

933:
934: CURSOR c_current_principal(c_khr_id NUMBER)
935: IS
936: SELECT sum(sele.amount)
937: FROM okl_strm_elements sele,
938: okl_streams str,
939: okl_strm_type_v sty
940: WHERE sele.stm_id = str.id
941: AND str.sty_id = sty.id

Line 950: FROM okl_strm_elements sele,

946: AND str.PURPOSE_CODE is NULL
947: --end multigaap changes
948: AND str.khr_id = c_khr_id
949: and sele.stream_element_date = (select max(sele.stream_element_date)
950: FROM okl_strm_elements sele,
951: okl_streams str,
952: okl_strm_type_v sty
953: WHERE sele.stm_id = str.id
954: AND str.sty_id = sty.id

Line 996: FROM okl_strm_elements sele,

992: l_parent_kle_id NUMBER;
993: CURSOR c_remaining_payments(c_kle_id NUMBER)
994: IS
995: SELECT count(sele.amount)
996: FROM okl_strm_elements sele,
997: okl_streams str,
998: okl_strm_type_v sty
999: WHERE sele.stm_id = str.id
1000: AND str.sty_id = sty.id

Line 1123: FROM okl_strm_elements sel,

1119:
1120: CURSOR c_get_remaining_payments(c_line_id NUMBER,c_pay_date DATE)
1121: IS
1122: SELECT count(sel.amount)
1123: FROM okl_strm_elements sel,
1124: okl_streams stm,
1125: okl_strm_type_v sty
1126: WHERE sty.name = 'PRINCIPAL PAYMENT'
1127: AND stm.sty_id = sty.id

Line 1135: FROM okl_strm_elements sel,okl_streams stm,

1131: AND stm.kle_id = c_line_id
1132: AND sel.stm_id = stm.id
1133: AND sel.stream_element_date >
1134: ( SELECT NVL(MAX(sel.stream_element_date), c_pay_date)
1135: FROM okl_strm_elements sel,okl_streams stm,
1136: okl_strm_type_v sty
1137: WHERE sty.name = 'PRINCIPAL PAYMENT'
1138: AND stm.sty_id = sty.id
1139: AND stm.say_code = 'CURR'

Line 7173: FROM OKL_STRM_ELEMENTS_V

7169: FROM dual;
7170:
7171: CURSOR c_stm_id_line_number(c_stm_id NUMBER) IS
7172: SELECT SE_LINE_NUMBER
7173: FROM OKL_STRM_ELEMENTS_V
7174: WHERE stm_id = c_stm_id
7175: ORDER BY SE_LINE_NUMBER DESC;
7176:
7177: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

Line 7733: -- to populate mandatory field in table Okl_Strm_Elements.

7729: --bug 4889833 commenting date billed
7730: --l_selv_rec.date_billed := SYSDATE;
7731: l_selv_rec.amount := l_trqv_rec.payment_amount;
7732:
7733: -- to populate mandatory field in table Okl_Strm_Elements.
7734: l_selv_rec.se_line_number := NULL;
7735: OPEN c_stm_id_line_number(l_selv_rec.stm_id);
7736: FETCH c_stm_id_line_number INTO l_selv_rec.se_line_number;
7737: if(c_stm_id_line_number%rowcount = 0) THEN