APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PRODUCT_PARAMETERS_V

Line 858: FROM okl_product_parameters_v

854: Revenue_Recognition_Method,
855: Interest_Calculation_Basis,
856: reporting_pdt_id,
857: reporting_product
858: FROM okl_product_parameters_v
859: WHERE id = cp_pdt_id;
860:
861: l_no_data_found BOOLEAN;
862: l_pdt_parameters_rec pdt_parameters_rec_type;

Line 1670: FROM okl_product_parameters_v a

1666:
1667:
1668: CURSOR c2(p_pdt_id NUMBER) IS
1669: SELECT '1'
1670: FROM okl_product_parameters_v a
1671: where a.id = p_pdt_id;
1672:
1673:
1674: CURSOR c1(p_pdt_id NUMBER) IS

Line 1676: FROM okl_product_parameters_v a,

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

Line 1698: select DEAL_TYPE from okl_product_parameters_v ppar

1694:
1695: AND a.id = p_pdt_id
1696: and a.aes_id = p_aes_id
1697: intersect
1698: select DEAL_TYPE from okl_product_parameters_v ppar
1699: where ppar.id = p_pdt_id;
1700:
1701:
1702: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

Line 1899: FROM okl_product_parameters_v pp

1895: revenue_recognition_method,
1896: revenue_recognition_meaning,
1897: interest_calculation_basis,
1898: interest_calculation_meaning
1899: FROM okl_product_parameters_v pp
1900: WHERE pp.id = p_pdt_id;
1901:
1902: CURSOR get_sgt_values_csr( p_pdt_id NUMBER)
1903: IS

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

1994: --
1995:
1996: /* Bug 7134895 */
1997: l_rpt_pdt_id OKL_PRODUCTS.ID%TYPE := null;
1998: l_rev_rec_method okl_product_parameters_v.revenue_recognition_method%TYPE := null;
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;

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

1995:
1996: /* Bug 7134895 */
1997: l_rpt_pdt_id OKL_PRODUCTS.ID%TYPE := null;
1998: l_rev_rec_method okl_product_parameters_v.revenue_recognition_method%TYPE := null;
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;

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

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

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

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