APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 1695: OKL_ST_GEN_TMPT_SETS c

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
1699: AND a.id = p_pdt_id;

Line 1708: OKL_ST_GEN_TMPT_SETS c

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:
1712: AND a.id = p_pdt_id

Line 1725: OKL_ST_GEN_TMPT_SETS c

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
1729: intersect

Line 1929: OKL_ST_GEN_TMPT_SETS GTS

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;
1933:

Line 1940: OKL_ST_GEN_TMPT_SETS c

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
1944: SELECT DISTINCT PQY.NAME

Line 1961: OKL_ST_GEN_TMPT_SETS GTSV,

1957: IS
1958: SELECT gttv.id gtt_id, gtsv.name name, gttv.version version
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

Line 2020: l_inv_deal_type OKL_ST_GEN_TMPT_SETS.deal_type%TYPE;

2016: l_int_calc_basis okl_product_parameters_v.interest_calculation_basis%TYPE := null;
2017: l_rpt_rev_rec_method okl_product_parameters_v.revenue_recognition_method%TYPE := null;
2018: l_rpt_int_calc_basis okl_product_parameters_v.interest_calculation_basis%TYPE := null;
2019: l_qv_found BOOLEAN;
2020: l_inv_deal_type OKL_ST_GEN_TMPT_SETS.deal_type%TYPE;
2021: -- Bug 6803437: Start
2022: l_rp_pdt_sts_code VARCHAR2(30);
2023: l_rp_pdt_name OKL_PRODUCTS_V.NAME%TYPE;
2024: l_raise_exception BOOLEAN := FALSE;

Line 3965: OKL_ST_GEN_TMPT_SETS c

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
3969: SELECT DISTINCT PQY.NAME

Line 4163: OKL_ST_GEN_TMPT_SETS c

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
4167: SELECT DISTINCT PQY.NAME