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_ST_GEN_TMPT_LNS

Line 917: okl_st_gen_tmpt_lns gtl,

913: CURSOR st_gen_tmpt_csr IS
914: SELECT
915: 'Y'
916: FROM
917: okl_st_gen_tmpt_lns gtl,
918: okl_st_gen_templates gtt,
919: okl_st_gen_tmpt_sets gts
920: WHERE
921: gtl.primary_sty_id = p_sty_id AND

Line 1256: l_pricing_name okl_st_gen_tmpt_lns.pricing_name%TYPE;

1252: FUNCTION Get_Pricing_Name (p_sty_code IN VARCHAR2)
1253: RETURN VARCHAR2
1254:
1255: IS
1256: l_pricing_name okl_st_gen_tmpt_lns.pricing_name%TYPE;
1257: BEGIN
1258:
1259: IF p_sty_code = 'PRE-TAX INCOME' THEN
1260: l_pricing_name := 'Single Rent Accrual';

Line 1499: l_pricing_name okl_st_gen_tmpt_lns.pricing_name%TYPE;

1495: FUNCTION Get_Sty_Purpose_Prc_Name (p_sty_purpose IN VARCHAR2)
1496: RETURN VARCHAR2
1497:
1498: IS
1499: l_pricing_name okl_st_gen_tmpt_lns.pricing_name%TYPE;
1500: BEGIN
1501:
1502: IF p_sty_purpose = 'FEE_PAYMENT' THEN
1503: l_pricing_name := 'Periodic Income';

Line 1583: (SELECT primary_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)

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',
1586: 'BILLING ADJUSTMENT',
1587: 'BOOK DEPRECIATION',

Line 1630: (SELECT primary_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)

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',
1633: 'CURE',
1634: 'FUNDING',

Line 1671: (SELECT primary_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)

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',
1674: 'INVESTOR DISBURSEMENT ADJUSTMENT',
1675: 'INVESTOR EVERGREEN RENT PAYABLE',

Line 1697: (SELECT dependent_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)

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',
1700: 'ADVANCED RENTALS',
1701: 'PRESENT VALUE RENT',

Line 1723: (SELECT dependent_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)

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',
1726: 'PRESENT VALUE RENT',
1727: 'EVERGREEN RENT',

Line 1749: (SELECT dependent_sty_id FROM okl_st_gen_tmpt_lns WHERE gtt_id = l_gtt_id)

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',
1752: 'VARIABLE INCOME ACCRUAL',
1753: 'ADVANCED RENTALS',

Line 2085: l_primary_yn okl_st_gen_tmpt_lns.primary_yn%TYPE;

2081: l_variable_sty_id NUMBER;
2082: j NUMBER := 0;
2083:
2084: l_sty_used VARCHAR2(1) := G_FALSE;
2085: l_primary_yn okl_st_gen_tmpt_lns.primary_yn%TYPE;
2086: l_primary_sty_id okl_st_gen_tmpt_lns.primary_sty_id%TYPE;
2087: l_dependent_sty_id okl_st_gen_tmpt_lns.dependent_sty_id%TYPE;
2088: l_pricing_name okl_st_gen_tmpt_lns.pricing_name%TYPE;
2089: l_dep_sty_tbl dep_sty_tbl;

Line 2086: l_primary_sty_id okl_st_gen_tmpt_lns.primary_sty_id%TYPE;

2082: j NUMBER := 0;
2083:
2084: l_sty_used VARCHAR2(1) := G_FALSE;
2085: l_primary_yn okl_st_gen_tmpt_lns.primary_yn%TYPE;
2086: l_primary_sty_id okl_st_gen_tmpt_lns.primary_sty_id%TYPE;
2087: l_dependent_sty_id okl_st_gen_tmpt_lns.dependent_sty_id%TYPE;
2088: l_pricing_name okl_st_gen_tmpt_lns.pricing_name%TYPE;
2089: l_dep_sty_tbl dep_sty_tbl;
2090:

Line 2087: l_dependent_sty_id okl_st_gen_tmpt_lns.dependent_sty_id%TYPE;

2083:
2084: l_sty_used VARCHAR2(1) := G_FALSE;
2085: l_primary_yn okl_st_gen_tmpt_lns.primary_yn%TYPE;
2086: l_primary_sty_id okl_st_gen_tmpt_lns.primary_sty_id%TYPE;
2087: l_dependent_sty_id okl_st_gen_tmpt_lns.dependent_sty_id%TYPE;
2088: l_pricing_name okl_st_gen_tmpt_lns.pricing_name%TYPE;
2089: l_dep_sty_tbl dep_sty_tbl;
2090:
2091: BEGIN

Line 2088: l_pricing_name okl_st_gen_tmpt_lns.pricing_name%TYPE;

2084: l_sty_used VARCHAR2(1) := G_FALSE;
2085: l_primary_yn okl_st_gen_tmpt_lns.primary_yn%TYPE;
2086: l_primary_sty_id okl_st_gen_tmpt_lns.primary_sty_id%TYPE;
2087: l_dependent_sty_id okl_st_gen_tmpt_lns.dependent_sty_id%TYPE;
2088: l_pricing_name okl_st_gen_tmpt_lns.pricing_name%TYPE;
2089: l_dep_sty_tbl dep_sty_tbl;
2090:
2091: BEGIN
2092: