APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 1678: OKL_ST_GEN_TMPT_SETS c

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

Line 1691: OKL_ST_GEN_TMPT_SETS c

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

Line 1912: OKL_ST_GEN_TMPT_SETS GTS

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

Line 1923: OKL_ST_GEN_TMPT_SETS c

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

Line 1944: OKL_ST_GEN_TMPT_SETS GTSV,

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

Line 2003: l_inv_deal_type OKL_ST_GEN_TMPT_SETS.deal_type%TYPE;

1999: l_int_calc_basis okl_product_parameters_v.interest_calculation_basis%TYPE := null;
2000: l_rpt_rev_rec_method okl_product_parameters_v.revenue_recognition_method%TYPE := null;
2001: l_rpt_int_calc_basis okl_product_parameters_v.interest_calculation_basis%TYPE := null;
2002: l_qv_found BOOLEAN;
2003: l_inv_deal_type OKL_ST_GEN_TMPT_SETS.deal_type%TYPE;
2004: -- Bug 6803437: Start
2005: l_rp_pdt_sts_code VARCHAR2(30);
2006: l_rp_pdt_name OKL_PRODUCTS_V.NAME%TYPE;
2007: l_raise_exception BOOLEAN := FALSE;

Line 3936: OKL_ST_GEN_TMPT_SETS c

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

Line 4134: OKL_ST_GEN_TMPT_SETS c

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