APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_STRM_TYPE_V

Line 892: okl_strm_type_v sty

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
895: AND UPPER(sty.name) = 'PRINCIPAL PAYMENT'
896: AND str.say_code = 'CURR'

Line 909: okl_strm_type_v sty

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
912: AND UPPER(sty.name) = 'PRINCIPAL BALANCE'
913: AND str.say_code = 'CURR'

Line 922: okl_strm_type_v sty

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
925: AND UPPER(sty.name) = 'PRINCIPAL PAYMENT'
926: AND str.say_code = 'CURR'

Line 939: okl_strm_type_v sty

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
942: AND UPPER(sty.name) = 'PRINCIPAL BALANCE'
943: AND str.say_code = 'CURR'

Line 952: okl_strm_type_v sty

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
955: AND UPPER(sty.name) = 'PRINCIPAL PAYMENT'
956: AND str.say_code = 'CURR'

Line 998: okl_strm_type_v sty

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
1001: AND UPPER(sty.name) = 'PRINCIPAL PAYMENT'
1002: AND str.say_code = 'CURR'

Line 1125: okl_strm_type_v sty

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
1128: AND stm.say_code = 'CURR'
1129: AND stm.active_yn = 'Y'

Line 1136: okl_strm_type_v sty

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'
1140: AND stm.active_yn = 'Y'