APPS.OKL_LA_STREAM_PVT dependencies on OKL_PRODUCTS_V

Line 3948: okl_products_v pdt

3944: khr.term_duration term,
3945: chr.orig_system_id1
3946: FROM okc_k_headers_v chr,
3947: okl_k_headers khr,
3948: okl_products_v pdt
3949: WHERE khr.id = chr.id
3950: AND chr.id = chrId
3951: AND khr.pdt_id = pdt.id(+);
3952: -- Get the Stream id

Line 7172: okl_products_v pdt

7168: SELECT 'Y'
7169: FROM DUAL
7170: WHERE EXISTS (SELECT 1
7171: FROM okl_k_headers khr,
7172: okl_products_v pdt
7173: WHERE khr.id = p_chr_id
7174: AND khr.pdt_id = pdt.id
7175: AND pdt.reporting_pdt_id IS NOT NULL);
7176: -- Check for reporting streams for non MGAPP prodcut

Line 9584: okl_products_v pdt,

9580: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
9581: gts.days_in_yr_code
9582: FROM
9583: okl_k_headers khr,
9584: okl_products_v pdt,
9585: okl_ae_tmpt_sets_v aes,
9586: OKL_ST_GEN_TMPT_SETS gts
9587: WHERE
9588: khr.pdt_id = pdt.id AND

Line 11960: okl_products_v pdt,

11956: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
11957: gts.days_in_yr_code
11958: FROM
11959: okl_k_headers khr,
11960: okl_products_v pdt,
11961: okl_ae_tmpt_sets_v aes,
11962: OKL_ST_GEN_TMPT_SETS gts
11963: WHERE
11964: khr.pdt_id = pdt.id AND

Line 13144: okl_products_v pdt,

13140: SELECT
13141: gts.interest_calc_meth_code
13142: FROM
13143: okl_k_headers khr,
13144: okl_products_v pdt,
13145: okl_ae_tmpt_sets_v aes,
13146: OKL_ST_GEN_TMPT_SETS gts
13147: WHERE
13148: khr.pdt_id = pdt.id AND

Line 13215: okl_products_v pdt,

13211: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
13212: gts.days_in_yr_code
13213: FROM
13214: okl_k_headers khr,
13215: okl_products_v pdt,
13216: okl_ae_tmpt_sets_v aes,
13217: OKL_ST_GEN_TMPT_SETS gts
13218: WHERE
13219: khr.pdt_id = pdt.id AND

Line 15290: okl_products_v pdt,

15286: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
15287: gts.days_in_yr_code
15288: FROM
15289: okl_k_headers khr,
15290: okl_products_v pdt,
15291: okl_ae_tmpt_sets_v aes,
15292: OKL_ST_GEN_TMPT_SETS gts
15293: WHERE
15294: khr.pdt_id = pdt.id AND

Line 17553: okl_products_v pdt

17549: chr.currency_code currency_code,
17550: khr.term_duration term
17551: FROM okc_k_headers_v chr,
17552: okl_k_headers khr,
17553: okl_products_v pdt
17554: WHERE khr.id = chr.id
17555: AND chr.id = chrId
17556: AND khr.pdt_id = pdt.id(+);
17557: -- get the Lease Header rule information

Line 17764: okl_products_v pdt,

17760: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
17761: gts.days_in_yr_code
17762: FROM
17763: okl_k_headers khr,
17764: okl_products_v pdt,
17765: okl_ae_tmpt_sets_v aes,
17766: OKL_ST_GEN_TMPT_SETS gts
17767: WHERE
17768: khr.pdt_id = pdt.id AND

Line 21887: okl_products_v pdt

21883: chr.currency_code currency_code,
21884: khr.term_duration term
21885: FROM okc_k_headers_v chr,
21886: okl_k_headers khr,
21887: okl_products_v pdt
21888: WHERE khr.id = chr.id
21889: AND chr.id = chrId
21890: AND khr.pdt_id = pdt.id(+);
21891: -- get the Header rule information

Line 22244: okl_products_v pdt,

22240: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
22241: gts.days_in_yr_code
22242: FROM
22243: okl_k_headers khr,
22244: okl_products_v pdt,
22245: okl_ae_tmpt_sets_v aes,
22246: OKL_ST_GEN_TMPT_SETS gts
22247: WHERE
22248: khr.pdt_id = pdt.id AND