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_LA_STREAM_PVT dependencies on OKL_PRODUCTS

Line 2598: okl_products pdt

2594: IS
2595: SELECT tst.isg_arrears_pay_dates_option
2596: FROM okl_st_gen_tmpt_sets tst,
2597: okl_ae_tmpt_sets aes,
2598: okl_products pdt
2599: WHERE pdt.id = p_pdt_id
2600: AND aes.id = pdt.aes_id
2601: AND tst.id = aes.gts_id;
2602:

Line 5047: okl_products_v pdt

5043: khr.term_duration term,
5044: chr.orig_system_id1
5045: FROM okc_k_headers_v chr,
5046: okl_k_headers khr,
5047: okl_products_v pdt
5048: WHERE khr.id = chr.id
5049: AND chr.id = chrId
5050: AND khr.pdt_id = pdt.id(+);
5051: -- Get the Stream id

Line 8063: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,

8059: and ole.lse_id = cle.lse_id
8060: and ole.id=cle.orig_system_id1;
8061: --smadhava - Bug# 6149951 - Added - End
8062: --Added by vdamerla for bug 6149951
8063: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,
8064: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS
8065: SELECT 'Y'
8066: FROM OKL_STRM_TYPE_B sty,
8067: OKL_PROD_STRM_TYPES psty

Line 8092: okl_products pdt

8088: --To get the reporting product id
8089: CURSOR c_get_report_product_id IS
8090: SELECT pdt.reporting_pdt_id
8091: FROM okl_k_headers khr,
8092: okl_products pdt
8093: WHERE khr.id = p_chr_id
8094: AND khr.pdt_id = pdt.id;
8095:
8096: --To check whether the accrual flag is checked or not

Line 8158: l_product_id okl_products.id%TYPE;

8154:
8155:
8156: l_accrual_previous_mnth_yn VARCHAR2(3);
8157: l_purpose_code okl_stream_interfaces.purpose_code%TYPE;
8158: l_product_id okl_products.id%TYPE;
8159: l_temp_term_date DATE;
8160: l_chk_accrual_stream VARCHAR2(1);
8161: l_curr_term_flag VARCHAR2(1);
8162: --end vdamerla

Line 8666: okl_products_v pdt

8662: SELECT 'Y'
8663: FROM DUAL
8664: WHERE EXISTS (SELECT 1
8665: FROM okl_k_headers khr,
8666: okl_products_v pdt
8667: WHERE khr.id = p_chr_id
8668: AND khr.pdt_id = pdt.id
8669: AND pdt.reporting_pdt_id IS NOT NULL);
8670: -- Check for reporting streams for non MGAPP prodcut

Line 11172: okl_products_v pdt,

11168: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
11169: gts.days_in_yr_code
11170: FROM
11171: okl_k_headers khr,
11172: okl_products_v pdt,
11173: okl_ae_tmpt_sets_v aes,
11174: OKL_ST_GEN_TMPT_SETS gts
11175: WHERE
11176: khr.pdt_id = pdt.id AND

Line 13890: okl_products_v pdt,

13886: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
13887: gts.days_in_yr_code
13888: FROM
13889: okl_k_headers khr,
13890: okl_products_v pdt,
13891: okl_ae_tmpt_sets_v aes,
13892: OKL_ST_GEN_TMPT_SETS gts
13893: WHERE
13894: khr.pdt_id = pdt.id AND

Line 15247: okl_products_v pdt,

15243: SELECT
15244: gts.interest_calc_meth_code
15245: FROM
15246: okl_k_headers khr,
15247: okl_products_v pdt,
15248: okl_ae_tmpt_sets_v aes,
15249: OKL_ST_GEN_TMPT_SETS gts
15250: WHERE
15251: khr.pdt_id = pdt.id AND

Line 15318: okl_products_v pdt,

15314: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
15315: gts.days_in_yr_code
15316: FROM
15317: okl_k_headers khr,
15318: okl_products_v pdt,
15319: okl_ae_tmpt_sets_v aes,
15320: OKL_ST_GEN_TMPT_SETS gts
15321: WHERE
15322: khr.pdt_id = pdt.id AND

Line 17603: okl_products_v pdt,

17599: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
17600: gts.days_in_yr_code
17601: FROM
17602: okl_k_headers khr,
17603: okl_products_v pdt,
17604: okl_ae_tmpt_sets_v aes,
17605: OKL_ST_GEN_TMPT_SETS gts
17606: WHERE
17607: khr.pdt_id = pdt.id AND

Line 20187: okl_products_v pdt

20183: chr.currency_code currency_code,
20184: khr.term_duration term
20185: FROM okc_k_headers_v chr,
20186: okl_k_headers khr,
20187: okl_products_v pdt
20188: WHERE khr.id = chr.id
20189: AND chr.id = chrId
20190: AND khr.pdt_id = pdt.id(+);
20191: -- get the Lease Header rule information

Line 20402: okl_products_v pdt,

20398: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
20399: gts.days_in_yr_code
20400: FROM
20401: okl_k_headers khr,
20402: okl_products_v pdt,
20403: okl_ae_tmpt_sets_v aes,
20404: OKL_ST_GEN_TMPT_SETS gts
20405: WHERE
20406: khr.pdt_id = pdt.id AND

Line 24730: okl_products_v pdt

24726: chr.currency_code currency_code,
24727: khr.term_duration term
24728: FROM okc_k_headers_v chr,
24729: okl_k_headers khr,
24730: okl_products_v pdt
24731: WHERE khr.id = chr.id
24732: AND chr.id = chrId
24733: AND khr.pdt_id = pdt.id(+);
24734: -- get the Header rule information

Line 25087: okl_products_v pdt,

25083: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
25084: gts.days_in_yr_code
25085: FROM
25086: okl_k_headers khr,
25087: okl_products_v pdt,
25088: okl_ae_tmpt_sets_v aes,
25089: OKL_ST_GEN_TMPT_SETS gts
25090: WHERE
25091: khr.pdt_id = pdt.id AND