DBA Data[Home] [Help]

APPS.OKL_BPD_TERMINATION_ADJ_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 468: OKL_ST_GEN_TMPT_SETS_ALL GTS

464: GTS.ISG_ARREARS_PAY_DATES_OPTION
465: FROM OKL_K_HEADERS KHR,
466: OKL_PRODUCTS PDT,
467: OKL_AE_TMPT_SETS_ALL AES,
468: OKL_ST_GEN_TMPT_SETS_ALL GTS
469: WHERE KHR.PDT_ID = PDT.ID
470: AND PDT.AES_ID = AES.ID
471: AND AES.GTS_ID = GTS.ID
472: AND KHR.ID = P_KHR_ID;

Line 487: l_pricing_engine OKL_ST_GEN_TMPT_SETS.PRICING_ENGINE%TYPE;

483: AND ROWNUM < 2;
484:
485: l_pmnt_arrear_flag VARCHAR2(1);
486: l_term_date_flag VARCHAR2(1);
487: l_pricing_engine OKL_ST_GEN_TMPT_SETS.PRICING_ENGINE%TYPE;
488: l_int_arrears_pay_option OKL_ST_GEN_TMPT_SETS.ISG_ARREARS_PAY_DATES_OPTION%TYPE;
489: --end Bug 7456516
490:
491: BEGIN

Line 488: l_int_arrears_pay_option OKL_ST_GEN_TMPT_SETS.ISG_ARREARS_PAY_DATES_OPTION%TYPE;

484:
485: l_pmnt_arrear_flag VARCHAR2(1);
486: l_term_date_flag VARCHAR2(1);
487: l_pricing_engine OKL_ST_GEN_TMPT_SETS.PRICING_ENGINE%TYPE;
488: l_int_arrears_pay_option OKL_ST_GEN_TMPT_SETS.ISG_ARREARS_PAY_DATES_OPTION%TYPE;
489: --end Bug 7456516
490:
491: BEGIN
492: l_return_status := OKL_API.START_ACTIVITY(l_api_name,