APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_AE_TMPT_SETS_V

Line 368: FROM Okl_Ae_Tmpt_Sets_V aes

364: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
365: p_to_date IN Okl_Products_V.TO_DATE%TYPE
366: ) IS
367: SELECT '1'
368: FROM Okl_Ae_Tmpt_Sets_V aes
369: WHERE aes.ID = p_aes_id
370: AND ((aes.START_DATE > p_from_date OR
371: p_from_date > NVL(aes.END_DATE,p_from_date)) OR
372: NVL(aes.END_DATE, p_to_date) < p_to_date)

Line 521: okl_ae_tmpt_sets_v aes,

517: p_db_pdtv_rec.aes_id <> p_pdtv_rec.aes_id THEN
518: SELECT COUNT(aes.id)
519: INTO l_pdt_psy_changed
520: FROM
521: okl_ae_tmpt_sets_v aes,
522: okl_prod_strm_types_v psy
523: WHERE aes.id = p_db_pdtv_rec.aes_id
524: and psy.pdt_id = p_upd_pdtv_rec.id;
525:

Line 1694: okl_ae_tmpt_sets_v b,

1690:
1691: CURSOR c1(p_pdt_id NUMBER) IS
1692: SELECT DISTINCT a.deal_type
1693: FROM okl_product_parameters_v a,
1694: okl_ae_tmpt_sets_v b,
1695: OKL_ST_GEN_TMPT_SETS c
1696: WHERE a.aes_id = b.id
1697: AND b.gts_id = c.id
1698: AND a.deal_type = c.deal_type

Line 1707: okl_ae_tmpt_sets_v b,

1703: p_aes_id okl_products_v.aes_id%TYPE)
1704: IS
1705: SELECT DISTINCT C.deal_type
1706: FROM okl_products_v a,
1707: okl_ae_tmpt_sets_v b,
1708: OKL_ST_GEN_TMPT_SETS c
1709: WHERE a.aes_id = b.id
1710: AND b.gts_id = c.id
1711:

Line 1724: okl_ae_tmpt_sets_v b,

1720: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
1721: IS
1722: SELECT DISTINCT C.deal_type
1723: FROM okl_products_v a,
1724: okl_ae_tmpt_sets_v b,
1725: OKL_ST_GEN_TMPT_SETS c
1726: WHERE a.aes_id = b.id
1727: AND b.gts_id = c.id
1728: AND a.id = p_pdt_id

Line 1928: OKL_AE_TMPT_SETS_V AES,

1924: gts.tax_owner,
1925: gts.interest_calc_meth_code,
1926: gts.revenue_recog_meth_code
1927: FROM OKL_PRODUCTS_V PDT,
1928: OKL_AE_TMPT_SETS_V AES,
1929: OKL_ST_GEN_TMPT_SETS GTS
1930: WHERE PDT.AES_ID = AES.ID
1931: AND AES.GTS_ID = GTS.ID
1932: AND PDT.ID = p_pdt_id;

Line 1939: FROM okl_ae_tmpt_sets_v b,

1935: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
1936: p_pdt_id IN Okl_Products_V.id%TYPE)
1937: IS
1938: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
1939: FROM okl_ae_tmpt_sets_v b,
1940: OKL_ST_GEN_TMPT_SETS c
1941: WHERE b.gts_id = c.id
1942: AND b.id = p_aes_id
1943: INTERSECT

Line 1963: okl_ae_tmpt_sets_v AES,

1959: FROM
1960: OKL_ST_GEN_TEMPLATES GTTV,
1961: OKL_ST_GEN_TMPT_SETS GTSV,
1962:
1963: okl_ae_tmpt_sets_v AES,
1964: okl_products_v PDT
1965: WHERE
1966: GTTV.gts_id = GTSV.id AND
1967: GTTV.tmpt_status = 'ACTIVE' AND

Line 2450: FROM okl_ae_tmpt_sets_v

2446: l_token_1 VARCHAR2(1999);
2447: CURSOR okl_aesv_pk_csr (p_id IN NUMBER) IS
2448:
2449: SELECT '1'
2450: FROM okl_ae_tmpt_sets_v
2451: WHERE okl_ae_tmpt_sets_v.id = p_id;
2452:
2453: BEGIN
2454: -- initialize return status

Line 2451: WHERE okl_ae_tmpt_sets_v.id = p_id;

2447: CURSOR okl_aesv_pk_csr (p_id IN NUMBER) IS
2448:
2449: SELECT '1'
2450: FROM okl_ae_tmpt_sets_v
2451: WHERE okl_ae_tmpt_sets_v.id = p_id;
2452:
2453: BEGIN
2454: -- initialize return status
2455: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 3964: FROM okl_ae_tmpt_sets_v b,

3960: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
3961: p_pdt_id IN Okl_Products_V.id%TYPE)
3962: IS
3963: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
3964: FROM okl_ae_tmpt_sets_v b,
3965: OKL_ST_GEN_TMPT_SETS c
3966: WHERE b.gts_id = c.id
3967: AND b.id = p_aes_id
3968: INTERSECT

Line 4162: FROM okl_ae_tmpt_sets_v b,

4158: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
4159: p_pdt_id IN Okl_Products_V.id%TYPE)
4160: IS
4161: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
4162: FROM okl_ae_tmpt_sets_v b,
4163: OKL_ST_GEN_TMPT_SETS c
4164: WHERE b.gts_id = c.id
4165: AND b.id = p_aes_id
4166: INTERSECT