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_STRM_GEN_TEMPLATE_PVT dependencies on FND_LOOKUPS

Line 4: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE

1: Package Body okl_strm_gen_template_pvt as
2: /* $Header: OKLRTSGB.pls 120.61 2011/07/08 07:42:01 vsgandhi ship $ */
3:
4: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
5: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
6: RETURN VARCHAR
7: IS
8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type

Line 5: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)

1: Package Body okl_strm_gen_template_pvt as
2: /* $Header: OKLRTSGB.pls 120.61 2011/07/08 07:42:01 vsgandhi ship $ */
3:
4: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
5: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
6: RETURN VARCHAR
7: IS
8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
9: ,p_lookup_code fnd_lookups.lookup_code%type)

Line 8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type

4: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
5: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
6: RETURN VARCHAR
7: IS
8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
9: ,p_lookup_code fnd_lookups.lookup_code%type)
10: IS
11: SELECT MEANING
12: FROM FND_LOOKUPS FND

Line 9: ,p_lookup_code fnd_lookups.lookup_code%type)

5: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
6: RETURN VARCHAR
7: IS
8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
9: ,p_lookup_code fnd_lookups.lookup_code%type)
10: IS
11: SELECT MEANING
12: FROM FND_LOOKUPS FND
13: WHERE FND.LOOKUP_TYPE = p_lookup_type

Line 12: FROM FND_LOOKUPS FND

8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
9: ,p_lookup_code fnd_lookups.lookup_code%type)
10: IS
11: SELECT MEANING
12: FROM FND_LOOKUPS FND
13: WHERE FND.LOOKUP_TYPE = p_lookup_type
14: AND FND.LOOKUP_CODE = p_lookup_code;
15:
16: l_return_value VARCHAR2(200) := OKL_API.G_MISS_CHAR;

Line 2148: FROM FND_LOOKUPS

2144:
2145: -- 3. All of the following primary purposes must be defined
2146: CURSOR fin_mandatory_pri_all_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2147: SELECT LOOKUP_CODE PURPOSE
2148: FROM FND_LOOKUPS
2149: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2150: AND LOOKUP_CODE IN
2151: (
2152: 'CURE'

Line 2212: FROM FND_LOOKUPS

2208: and GTL.GTT_ID = p_gtt_id;
2209:
2210: CURSOR fin_mandatory_pri_ln_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2211: SELECT LOOKUP_CODE PURPOSE
2212: FROM FND_LOOKUPS
2213: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2214: AND LOOKUP_CODE IN
2215: (
2216: 'VARIABLE_INTEREST'

Line 2232: FROM FND_LOOKUPS

2228: and GTL.GTT_ID = p_gtt_id;
2229:
2230: CURSOR fin_mandatory_pri_ls_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2231: SELECT LOOKUP_CODE PURPOSE
2232: FROM FND_LOOKUPS
2233: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2234: AND LOOKUP_CODE IN
2235: (
2236: 'RESIDUAL_VALUE'

Line 2253: FROM FND_LOOKUPS

2249:
2250: --Bug 5139013 dpsingh start
2251: CURSOR fin_mandatory_pri_ic_float_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2252: SELECT LOOKUP_CODE PURPOSE
2253: FROM FND_LOOKUPS
2254: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2255: AND LOOKUP_CODE ='VARIABLE_INTEREST_SCHEDULE'
2256: MINUS
2257: SELECT distinct stb.stream_type_purpose purpose

Line 2270: FROM FND_LOOKUPS

2266: -- Modified by RGOOTY
2267: -- Bug 4111081: Start
2268: CURSOR fin_mandatory_pri_op_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2269: SELECT LOOKUP_CODE PURPOSE
2270: FROM FND_LOOKUPS
2271: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2272: AND LOOKUP_CODE IN
2273: (
2274: 'INVESTOR_RENTAL_ACCRUAL'

Line 2290: FROM FND_LOOKUPS

2286: and GTL.GTT_ID = p_gtt_id;
2287:
2288: CURSOR fin_mandatory_pri_df_n_st_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2289: SELECT LOOKUP_CODE PURPOSE
2290: FROM FND_LOOKUPS
2291: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2292: AND LOOKUP_CODE IN
2293: (
2294: 'INVESTOR_PRETAX_INCOME'

Line 2315: FROM FND_LOOKUPS

2311:
2312: -- 4. Mandatory Dependent Streams
2313: CURSOR man_dep_all_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2314: SELECT LOOKUP_CODE PURPOSE
2315: FROM FND_LOOKUPS
2316: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2317: AND LOOKUP_CODE IN
2318: (
2319: 'ADVANCE_RENT'

Line 2349: FROM FND_LOOKUPS

2345: );
2346:
2347: CURSOR man_dep_ln_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2348: SELECT LOOKUP_CODE PURPOSE
2349: FROM FND_LOOKUPS
2350: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2351: AND LOOKUP_CODE IN
2352: (
2353: 'INTEREST_INCOME'

Line 2395: FROM FND_LOOKUPS

2391: );
2392:
2393: CURSOR man_dep_ln_vrs_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2394: SELECT LOOKUP_CODE PURPOSE
2395: FROM FND_LOOKUPS
2396: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2397: AND LOOKUP_CODE IN
2398: (
2399: 'DAILY_INTEREST_PRINCIPAL'

Line 2443: FROM FND_LOOKUPS

2439: );
2440:
2441: CURSOR man_dep_dfstop_vrs_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2442: SELECT LOOKUP_CODE PURPOSE
2443: FROM FND_LOOKUPS
2444: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2445: AND LOOKUP_CODE IN
2446: (
2447: 'FLOAT_FACTOR_ADJUSTMENT'

Line 2477: FROM FND_LOOKUPS

2473: );
2474:
2475: CURSOR man_dep_ln_icc_vrs_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2476: SELECT LOOKUP_CODE PURPOSE
2477: FROM FND_LOOKUPS
2478: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2479: AND LOOKUP_CODE IN
2480: (
2481: 'INTEREST_CATCHUP'

Line 2512: FROM FND_LOOKUPS

2508:
2509: -- rgooty BUG#4290143 start
2510: CURSOR man_dep_ln_var_int_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2511: SELECT LOOKUP_CODE PURPOSE
2512: FROM FND_LOOKUPS
2513: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2514: AND LOOKUP_CODE = 'VARIABLE_INTEREST_INCOME'
2515: MINUS
2516: SELECT distinct stb.stream_type_purpose purpose

Line 2541: FROM FND_LOOKUPS

2537: -- rgooty BUG#4290143 end
2538:
2539: CURSOR man_dep_df_st_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2540: SELECT LOOKUP_CODE PURPOSE
2541: FROM FND_LOOKUPS
2542: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2543: AND LOOKUP_CODE IN
2544: (
2545: 'LEASE_INCOME'

Line 2575: FROM FND_LOOKUPS

2571: );
2572:
2573: CURSOR man_dep_ls_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2574: SELECT LOOKUP_CODE PURPOSE
2575: FROM FND_LOOKUPS
2576: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2577: AND LOOKUP_CODE IN
2578: (
2579: 'PASS_THROUGH_EVERGREEN_RENT'

Line 2613: FROM FND_LOOKUPS

2609: );
2610:
2611: CURSOR man_dep_ls_rv_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2612: SELECT LOOKUP_CODE PURPOSE
2613: FROM FND_LOOKUPS
2614: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2615: AND LOOKUP_CODE IN
2616: (
2617: 'PV_RV'

Line 2659: FROM FND_LOOKUPS

2655: );
2656:
2657: CURSOR man_dep_op_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2658: SELECT LOOKUP_CODE PURPOSE
2659: FROM FND_LOOKUPS
2660: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2661: AND LOOKUP_CODE IN
2662: (
2663: 'RENT_ACCRUAL'

Line 2713: FROM FND_LOOKUPS

2709: and GTL.GTT_ID = p_gtt_id
2710: )
2711: MINUS
2712: SELECT LOOKUP_CODE
2713: FROM FND_LOOKUPS
2714: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2715: AND LOOKUP_CODE in
2716: (
2717: 'ACCOUNTING'

Line 2874: FROM FND_LOOKUPS

2870: and GTL.GTT_ID = p_gtt_id
2871: )
2872: MINUS
2873: SELECT LOOKUP_CODE
2874: FROM FND_LOOKUPS
2875: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2876: AND LOOKUP_CODE in
2877: (
2878: 'ACCOUNTING'

Line 3035: FROM FND_LOOKUPS

3031: and GTL.GTT_ID = p_gtt_id
3032: )
3033: MINUS
3034: SELECT LOOKUP_CODE
3035: FROM FND_LOOKUPS
3036: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
3037: AND LOOKUP_CODE in
3038: (
3039: 'ACCOUNTING'

Line 3743: FROM FND_LOOKUPS

3739:
3740: -- 3. All of the following primary purposes must be defined
3741: CURSOR inv_mandatory_primary_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
3742: SELECT LOOKUP_CODE PURPOSE
3743: FROM FND_LOOKUPS
3744: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
3745: AND LOOKUP_CODE IN
3746: (
3747: 'INVESTOR_CNTRCT_OBLIGATION_PAY'

Line 4052: FROM FND_LOOKUPS

4048: CURSOR fee_payment_man_dep_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type
4049: ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.primary_sty_id%TYPE
4050: ,p_exclude_fr IN VARCHAR2 ) IS
4051: SELECT LOOKUP_CODE PURPOSE
4052: FROM FND_LOOKUPS
4053: WHERE LOOKUP_TYPE = G_OKL_FIN_DEPENDENT_PURPOSES
4054: AND LOOKUP_CODE IN
4055: (
4056: 'AMORTIZE_FEE_INCOME'

Line 4542: FND_LOOKUPS

4538: CURSOR okl_dep_purpose_dup_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%TYPE
4539: ,p_pri_id IN OKL_ST_GEN_TMPT_LNS.primary_Sty_id%TYPE) IS
4540: SELECT STY.STREAM_TYPE_PURPOSE PURPOSE_CODE,
4541: ( SELECT MEANING FROM
4542: FND_LOOKUPS
4543: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
4544: AND LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE
4545: ) PURPOSE_MEANING,
4546: COUNT( STY.STREAM_TYPE_PURPOSE) streams_count

Line 4855: FROM FND_LOOKUPS

4851: STYP.STREAM_TYPE_PURPOSE PRI_STRM_TYPE_PURPOSE,
4852: -- gboomina Bug 4874272 - Added - End
4853: STY.STREAM_TYPE_PURPOSE DEP_PURPOSE_CODE,
4854: ( SELECT MEANING
4855: FROM FND_LOOKUPS
4856: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
4857: AND LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE
4858: ) DEP_PURPOSE_MEANING,
4859: COUNT( STY.STREAM_TYPE_PURPOSE) streams_count