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 519: okl_ae_tmpt_sets_v aes,

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

Line 1677: okl_ae_tmpt_sets_v b,

1673:
1674: CURSOR c1(p_pdt_id NUMBER) IS
1675: SELECT DISTINCT a.deal_type
1676: FROM okl_product_parameters_v a,
1677: okl_ae_tmpt_sets_v b,
1678: OKL_ST_GEN_TMPT_SETS c
1679: WHERE a.aes_id = b.id
1680: AND b.gts_id = c.id
1681: AND a.deal_type = c.deal_type

Line 1690: okl_ae_tmpt_sets_v b,

1686: p_aes_id okl_products_v.aes_id%TYPE)
1687: IS
1688: SELECT DISTINCT C.deal_type
1689: FROM okl_products_v a,
1690: okl_ae_tmpt_sets_v b,
1691: OKL_ST_GEN_TMPT_SETS c
1692: WHERE a.aes_id = b.id
1693: AND b.gts_id = c.id
1694:

Line 1707: okl_ae_tmpt_sets_v b,

1703: p_qve_id okl_pdt_pqy_vals_v.qve_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: AND a.id = p_pdt_id

Line 1911: OKL_AE_TMPT_SETS_V AES,

1907: gts.tax_owner,
1908: gts.interest_calc_meth_code,
1909: gts.revenue_recog_meth_code
1910: FROM OKL_PRODUCTS_V PDT,
1911: OKL_AE_TMPT_SETS_V AES,
1912: OKL_ST_GEN_TMPT_SETS GTS
1913: WHERE PDT.AES_ID = AES.ID
1914: AND AES.GTS_ID = GTS.ID
1915: AND PDT.ID = p_pdt_id;

Line 1922: FROM okl_ae_tmpt_sets_v b,

1918: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
1919: p_pdt_id IN Okl_Products_V.id%TYPE)
1920: IS
1921: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
1922: FROM okl_ae_tmpt_sets_v b,
1923: OKL_ST_GEN_TMPT_SETS c
1924: WHERE b.gts_id = c.id
1925: AND b.id = p_aes_id
1926: INTERSECT

Line 1946: okl_ae_tmpt_sets_v AES,

1942: FROM
1943: OKL_ST_GEN_TEMPLATES GTTV,
1944: OKL_ST_GEN_TMPT_SETS GTSV,
1945:
1946: okl_ae_tmpt_sets_v AES,
1947: okl_products_v PDT
1948: WHERE
1949: GTTV.gts_id = GTSV.id AND
1950: GTTV.tmpt_status = 'ACTIVE' AND

Line 2421: FROM okl_ae_tmpt_sets_v

2417: l_token_1 VARCHAR2(1999);
2418: CURSOR okl_aesv_pk_csr (p_id IN NUMBER) IS
2419:
2420: SELECT '1'
2421: FROM okl_ae_tmpt_sets_v
2422: WHERE okl_ae_tmpt_sets_v.id = p_id;
2423:
2424: BEGIN
2425: -- initialize return status

Line 2422: WHERE okl_ae_tmpt_sets_v.id = p_id;

2418: CURSOR okl_aesv_pk_csr (p_id IN NUMBER) IS
2419:
2420: SELECT '1'
2421: FROM okl_ae_tmpt_sets_v
2422: WHERE okl_ae_tmpt_sets_v.id = p_id;
2423:
2424: BEGIN
2425: -- initialize return status
2426: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 3935: FROM okl_ae_tmpt_sets_v b,

3931: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
3932: p_pdt_id IN Okl_Products_V.id%TYPE)
3933: IS
3934: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
3935: FROM okl_ae_tmpt_sets_v b,
3936: OKL_ST_GEN_TMPT_SETS c
3937: WHERE b.gts_id = c.id
3938: AND b.id = p_aes_id
3939: INTERSECT

Line 4133: FROM okl_ae_tmpt_sets_v b,

4129: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
4130: p_pdt_id IN Okl_Products_V.id%TYPE)
4131: IS
4132: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
4133: FROM okl_ae_tmpt_sets_v b,
4134: OKL_ST_GEN_TMPT_SETS c
4135: WHERE b.gts_id = c.id
4136: AND b.id = p_aes_id
4137: INTERSECT