APPS.OKL_LA_STREAM_PVT dependencies on OKL_SYS_ACCT_OPTS

Line 3164: from okl_sys_acct_opts;

3160:
3161: --sechawla 10-aug-09 : PRB ESG enhancements : begin
3162: cursor get_rebook_type is
3163: select nvl(amort_inc_adj_rev_dt_yn, 'N')
3164: from okl_sys_acct_opts;
3165:
3166: -- Prospective Rebooking Enhancement
3167: CURSOR sg_during_rbk_csr( p_khr_id IN NUMBER)
3168: IS

Line 10226: from okl_sys_acct_opts;

10222:
10223: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
10224: cursor get_rebook_type is
10225: select nvl(amort_inc_adj_rev_dt_yn, 'N')
10226: from okl_sys_acct_opts;
10227:
10228: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
10229:
10230:

Line 10544: from okl_sys_acct_opts;

10540:
10541: --sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
10542: cursor get_rebook_type is
10543: select nvl(amort_inc_adj_rev_dt_yn, 'N')
10544: from okl_sys_acct_opts;
10545: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
10546:
10547: BEGIN
10548: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 11245: from okl_sys_acct_opts;

11241:
11242: --sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
11243: cursor get_rebook_type is
11244: select nvl(amort_inc_adj_rev_dt_yn, 'N')
11245: from okl_sys_acct_opts;
11246: l_PROSPECTIVE_REBOOK_YN varchar2(1);
11247:
11248: l_calc_disb_amount NUMBER;
11249: l_disb_amount NUMBER;

Line 13917: from okl_sys_acct_opts;

13913:
13914: --sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
13915: cursor get_rebook_type is
13916: select nvl(amort_inc_adj_rev_dt_yn, 'N')
13917: from okl_sys_acct_opts;
13918: l_PROSPECTIVE_REBOOK_YN varchar2(1);
13919:
13920:
13921: l_base_rate NUMBER;

Line 15239: from okl_sys_acct_opts;

15235:
15236: --sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
15237: cursor get_rebook_type is
15238: select nvl(amort_inc_adj_rev_dt_yn, 'N')
15239: from okl_sys_acct_opts;
15240: l_PROSPECTIVE_REBOOK_YN varchar2(1);
15241:
15242: Cursor check_fixed_contract(chrId VARCHAR2) is
15243: SELECT

Line 17679: from okl_sys_acct_opts;

17675:
17676: --sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
17677: cursor get_rebook_type is
17678: select nvl(amort_inc_adj_rev_dt_yn, 'N')
17679: from okl_sys_acct_opts;
17680: l_PROSPECTIVE_REBOOK_YN varchar2(1);
17681:
17682:
17683: FUNCTION get_end_date(

Line 20493: from okl_sys_acct_opts;

20489:
20490: --sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
20491: cursor get_rebook_type is
20492: select nvl(amort_inc_adj_rev_dt_yn, 'N')
20493: from okl_sys_acct_opts;
20494: l_PROSPECTIVE_REBOOK_YN varchar2(1);
20495:
20496: BEGIN
20497: --Added by kthiruva for Debugging

Line 20825: -- OKL_SYS_ACCT_OPTS table are stored with regards to the context

20821:
20822: l_csm_line_details_tbl(i).description := l_line_rec.item_description;
20823:
20824: -- we need to set the context since the records in
20825: -- OKL_SYS_ACCT_OPTS table are stored with regards to the context
20826: -- To calculate basis percent for Corp or tax book
20827: -- we need the Line capital amount.
20828: -- Now since new version of the pricing eng
20829: -- NET subsidies , amount of sudsidy is sent to

Line 23200: from okl_sys_acct_opts;

23196: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;
23197:
23198: cursor get_rebook_type is
23199: select nvl(amort_inc_adj_rev_dt_yn, 'N')
23200: from okl_sys_acct_opts;
23201:
23202: l_PROSPECTIVE_REBOOK_YN varchar2(1);
23203:
23204: BEGIN

Line 25408: -- OKL_SYS_ACCT_OPTS table are stored with regards to the context

25404: l_csm_line_details_tbl(i).date_funding := NVL(l_line_rec.date_funding,l_line_rec.start_date);
25405: --smahapat end change 03/13/04
25406: l_csm_line_details_tbl(i).description := l_line_rec.item_description;
25407: -- we need to set the context since the records in
25408: -- OKL_SYS_ACCT_OPTS table are stored with regards to the context
25409: -- To calculate basis percent for Corp or tax book
25410: -- we need the Line capital amount.
25411: -- Now since new version of the pricing eng
25412: -- NET subsidies , amount of sudsidy is sent to