eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STREAM_MIGRATION_PVT dependencies on OKL_STRM_TYPE_V

Line 499: FROM okl_strm_type_v

495: -- Cursor to find if a stream type is used in Subsidy.
496:
497: CURSOR subsidy_csr (l_sty_id NUMBER) IS
498: SELECT stream_type_class
499: FROM okl_strm_type_v
500: WHERE stream_type_class = 'SUBSIDY'
501: AND id = l_sty_id;
502:
503: BEGIN

Line 805: okl_strm_type_v

801: stream_type_purpose,
802: start_date,
803: stream_type_class
804: FROM
805: okl_strm_type_v
806: WHERE
807: short_description IS NULL;
808:
809: l_new_sty_purpose VARCHAR2(100);

Line 1329: FROM OKL_STRM_TYPE_V

1325: WHERE id = p_sty_id;
1326:
1327: CURSOR act_prpty_tax_csr IS
1328: SELECT ID, CODE , stream_type_purpose
1329: FROM OKL_STRM_TYPE_V
1330: WHERE CODE IN
1331: ('ADJUSTED PROPERTY TAX');
1332:
1333: CURSOR est_prpty_tax_csr IS

Line 1335: FROM OKL_STRM_TYPE_V

1331: ('ADJUSTED PROPERTY TAX');
1332:
1333: CURSOR est_prpty_tax_csr IS
1334: SELECT ID, CODE , stream_type_purpose
1335: FROM OKL_STRM_TYPE_V
1336: WHERE CODE IN
1337: ('RENEWAL PROPERTY TAX');
1338:
1339: CURSOR expense_csr IS

Line 1341: FROM OKL_STRM_TYPE_V

1337: ('RENEWAL PROPERTY TAX');
1338:
1339: CURSOR expense_csr IS
1340: SELECT ID, CODE , stream_type_purpose
1341: FROM OKL_STRM_TYPE_V
1342: WHERE CODE IN
1343: ('ACCRUED FEE EXPENSE',
1344: 'AMORTIZED EXPENSE');
1345:

Line 1348: FROM OKL_STRM_TYPE_V

1344: 'AMORTIZED EXPENSE');
1345:
1346: CURSOR fee_payment_csr IS
1347: SELECT ID, CODE , stream_type_purpose
1348: FROM OKL_STRM_TYPE_V
1349: WHERE CODE IN
1350: (
1351: 'FEE INCOME',
1352: 'AMORTIZED FEE INCOME',

Line 1365: FROM OKL_STRM_TYPE_V

1361: 'PASS THROUGH REVENUE ACCRUAL');
1362:
1363: CURSOR passthru_srv_csr IS
1364: SELECT ID, CODE , stream_type_purpose
1365: FROM OKL_STRM_TYPE_V
1366: WHERE CODE IN
1367: ('PASS THROUGH SERVICE EXPENSE ACCRUAL');
1368:
1369: CURSOR srv_payment_csr IS

Line 1371: FROM OKL_STRM_TYPE_V

1367: ('PASS THROUGH SERVICE EXPENSE ACCRUAL');
1368:
1369: CURSOR srv_payment_csr IS
1370: SELECT ID, CODE , stream_type_purpose
1371: FROM OKL_STRM_TYPE_V
1372: WHERE CODE IN
1373: ('PASS THROUGH EVERGREEN SERVICE',
1374: 'PASS THROUGH SERVICE REVENUE ACCRUAL',
1375: 'SERVICE INCOME',

Line 1380: FROM OKL_STRM_TYPE_V STY, okl_sgn_translations sgn

1376: 'SERVICE AND MAINTENANCE EVERGREEN');
1377:
1378: CURSOR subsidy_csr IS
1379: SELECT STY.ID, STY.CODE , STY.stream_type_purpose
1380: FROM OKL_STRM_TYPE_V STY, okl_sgn_translations sgn
1381: WHERE sgn.object1_id1 = TO_CHAR(p_sty_id)
1382: AND sgn.value = TO_CHAR(sty.id);
1383:
1384: l_dep_sty_tbl dep_sty_tbl;

Line 1581: SELECT id, code, stream_type_purpose FROM okl_strm_type_v

1577:
1578: -- Cursor to fetch the mandatory stream type for a lease contract
1579:
1580: CURSOR lease_primary_csr (l_gtt_id NUMBER) IS
1581: SELECT id, code, stream_type_purpose FROM okl_strm_type_v
1582: WHERE id NOT IN
1583: (SELECT primary_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)
1584: AND code IN (
1585: 'ASSET REPAIR CHARGE',

Line 1628: SELECT id, code, stream_type_purpose FROM okl_strm_type_v

1624:
1625: -- Cursor to fetch the mandatory stream type for a loan contract
1626:
1627: CURSOR loan_csr (l_gtt_id NUMBER) IS
1628: SELECT id, code, stream_type_purpose FROM okl_strm_type_v
1629: WHERE id NOT IN
1630: (SELECT primary_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)
1631: AND code IN (
1632: 'BILLING ADJUSTMENT',

Line 1669: SELECT id, code FROM okl_strm_type_v

1665:
1666: -- Cursor to fetch the mandatory stream type for a investor contract
1667:
1668: CURSOR investor_csr (l_gtt_id NUMBER) IS
1669: SELECT id, code FROM okl_strm_type_v
1670: WHERE id NOT IN
1671: (SELECT primary_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)
1672: AND code IN (
1673: 'INVESTOR CONTRACT OBLIGATION PAYABLE',

Line 1695: SELECT id, code FROM okl_strm_type_v

1691:
1692: -- Cursor to fetch the dependent stream type for a leaseop contract
1693:
1694: CURSOR leaseop_dep_csr (l_gtt_id NUMBER) IS
1695: SELECT id, code FROM okl_strm_type_v
1696: WHERE id NOT IN
1697: (SELECT dependent_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)
1698: AND code IN (
1699: 'RENTAL ACCRUAL',

Line 1721: SELECT id, code FROM okl_strm_type_v

1717:
1718: -- Cursor to fetch the dependent stream type for a leasest/leasedf contract
1719:
1720: CURSOR leasedf_st_dep_csr (l_gtt_id NUMBER) IS
1721: SELECT id, code FROM okl_strm_type_v
1722: WHERE id NOT IN
1723: (SELECT dependent_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)
1724: AND code IN (
1725: 'ADVANCED RENTALS',

Line 1747: SELECT id, code FROM okl_strm_type_v

1743:
1744: -- Cursor to fetch the dependent stream type for a loan contract
1745:
1746: CURSOR loan_dep_csr (l_gtt_id NUMBER) IS
1747: SELECT id, code FROM okl_strm_type_v
1748: WHERE id NOT IN
1749: (SELECT dependent_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)
1750: AND code IN (
1751: 'VARIABLE INCOME NON-ACCRUAL',

Line 2076: okl_strm_type_v;

2072: stream_type_purpose,
2073: start_date,
2074: stream_type_class
2075: FROM
2076: okl_strm_type_v;
2077:
2078: l_gtlv_tbl gtlv_tbl_type;
2079: l_rent_sty_id NUMBER;
2080: l_rv_sty_id NUMBER;

Line 2260: okl_strm_type_v;

2256: stream_type_purpose,
2257: start_date,
2258: stream_type_class
2259: FROM
2260: okl_strm_type_v;
2261:
2262: -- Cursor to find out if the stream types have been migrated or not.
2263:
2264: CURSOR sty_mig_csr IS

Line 2266: FROM OKL_STRM_TYPE_V STY

2262: -- Cursor to find out if the stream types have been migrated or not.
2263:
2264: CURSOR sty_mig_csr IS
2265: SELECT '1'
2266: FROM OKL_STRM_TYPE_V STY
2267: WHERE STY.SHORT_DESCRIPTION <> 'UPGRADED SUCCESSFULLY';
2268:
2269: -- Cusrsor to get the distinct operating units in the system
2270: