APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PRODUCT_PARAMETERS_V

Line 875: FROM okl_product_parameters_v

871: Revenue_Recognition_Method,
872: Interest_Calculation_Basis,
873: reporting_pdt_id,
874: reporting_product
875: FROM okl_product_parameters_v
876: WHERE id = cp_pdt_id;
877:
878: l_no_data_found BOOLEAN;
879: l_pdt_parameters_rec pdt_parameters_rec_type;

Line 1687: FROM okl_product_parameters_v a

1683:
1684:
1685: CURSOR c2(p_pdt_id NUMBER) IS
1686: SELECT '1'
1687: FROM okl_product_parameters_v a
1688: where a.id = p_pdt_id;
1689:
1690:
1691: CURSOR c1(p_pdt_id NUMBER) IS

Line 1693: FROM okl_product_parameters_v a,

1689:
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

Line 1715: select DEAL_TYPE from okl_product_parameters_v ppar

1711:
1712: AND a.id = p_pdt_id
1713: and a.aes_id = p_aes_id
1714: intersect
1715: select DEAL_TYPE from okl_product_parameters_v ppar
1716: where ppar.id = p_pdt_id;
1717:
1718:
1719: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

Line 1916: FROM okl_product_parameters_v pp

1912: revenue_recognition_method,
1913: revenue_recognition_meaning,
1914: interest_calculation_basis,
1915: interest_calculation_meaning
1916: FROM okl_product_parameters_v pp
1917: WHERE pp.id = p_pdt_id;
1918:
1919: CURSOR get_sgt_values_csr( p_pdt_id NUMBER)
1920: IS

Line 2015: l_rev_rec_method okl_product_parameters_v.revenue_recognition_method%TYPE := null;

2011: --
2012:
2013: /* Bug 7134895 */
2014: l_rpt_pdt_id OKL_PRODUCTS.ID%TYPE := null;
2015: l_rev_rec_method okl_product_parameters_v.revenue_recognition_method%TYPE := null;
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;

Line 2016: l_int_calc_basis okl_product_parameters_v.interest_calculation_basis%TYPE := null;

2012:
2013: /* Bug 7134895 */
2014: l_rpt_pdt_id OKL_PRODUCTS.ID%TYPE := null;
2015: l_rev_rec_method okl_product_parameters_v.revenue_recognition_method%TYPE := null;
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;

Line 2017: l_rpt_rev_rec_method okl_product_parameters_v.revenue_recognition_method%TYPE := null;

2013: /* Bug 7134895 */
2014: l_rpt_pdt_id OKL_PRODUCTS.ID%TYPE := null;
2015: l_rev_rec_method okl_product_parameters_v.revenue_recognition_method%TYPE := null;
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

Line 2018: l_rpt_int_calc_basis okl_product_parameters_v.interest_calculation_basis%TYPE := null;

2014: l_rpt_pdt_id OKL_PRODUCTS.ID%TYPE := null;
2015: l_rev_rec_method okl_product_parameters_v.revenue_recognition_method%TYPE := null;
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);