DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 12904: okl_st_gen_tmpt_sets_all gts

12900: gts.isg_arrears_pay_dates_option
12901: FROM okl_k_headers khr,
12902: okl_products pdt,
12903: okl_ae_tmpt_sets_all aes,
12904: okl_st_gen_tmpt_sets_all gts
12905: WHERE khr.pdt_id = pdt.id
12906: AND pdt.aes_id = aes.id
12907: AND aes.gts_id = gts.id
12908: AND khr.id = p_khr_id;

Line 12942: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;

12938:
12939: l_pricing_name OKL_ST_GEN_TMPT_LNS_ALL.pricing_name%TYPE;
12940: l_pmnt_arrear_flag VARCHAR2(1);
12941: l_term_date_flag VARCHAR2(1);
12942: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
12943: l_int_arrears_pay_option OKL_ST_GEN_TMPT_SETS.isg_arrears_pay_dates_option%TYPE;
12944: --end Bug 10075141
12945:
12946: -- 13246259 get contract end date

Line 12943: l_int_arrears_pay_option OKL_ST_GEN_TMPT_SETS.isg_arrears_pay_dates_option%TYPE;

12939: l_pricing_name OKL_ST_GEN_TMPT_LNS_ALL.pricing_name%TYPE;
12940: l_pmnt_arrear_flag VARCHAR2(1);
12941: l_term_date_flag VARCHAR2(1);
12942: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
12943: l_int_arrears_pay_option OKL_ST_GEN_TMPT_SETS.isg_arrears_pay_dates_option%TYPE;
12944: --end Bug 10075141
12945:
12946: -- 13246259 get contract end date
12947: CURSOR get_chr_end_date_csr (p_khr_id IN NUMBER) IS