APPS.OKL_LA_STREAM_PVT dependencies on OKL_PRODUCTS_V

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 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