APPS.OKL_CREATE_STREAMS_PVT dependencies on OKL_SYS_ACCT_OPTS

Line 684: from okl_sys_acct_opts;

680:
681: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
682: cursor get_rebook_type is
683: select nvl(amort_inc_adj_rev_dt_yn, 'N')
684: from okl_sys_acct_opts;
685:
686: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
687:
688: lp_silv_rec silv_rec_type;

Line 828: from okl_sys_acct_opts;

824:
825: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
826: cursor get_rebook_type is
827: select nvl(amort_inc_adj_rev_dt_yn, 'N')
828: from okl_sys_acct_opts;
829:
830: --sechawla 24-Jul-09 PRB ESG Enhancements : get orig_contract_line_id for the subsidy line
831: cursor get_orig_subsidy_line_id(cp_subsidy_line_id in number) is
832: select orig_contract_line_id

Line 981: from okl_sys_acct_opts;

977: i NUMBER := 0;
978: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
979: cursor get_rebook_type is
980: select nvl(amort_inc_adj_rev_dt_yn, 'N')
981: from okl_sys_acct_opts;
982:
983: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
984:
985: BEGIN

Line 1112: from okl_sys_acct_opts;

1108:
1109: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
1110: cursor get_rebook_type is
1111: select nvl(amort_inc_adj_rev_dt_yn, 'N')
1112: from okl_sys_acct_opts;
1113:
1114: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
1115:
1116: BEGIN

Line 1488: from okl_sys_acct_opts;

1484:
1485: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
1486: cursor get_rebook_type is
1487: select nvl(amort_inc_adj_rev_dt_yn, 'N')
1488: from okl_sys_acct_opts;
1489:
1490: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
1491:
1492: lp_silv_rec silv_rec_type;

Line 1611: from okl_sys_acct_opts;

1607:
1608: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
1609: cursor get_rebook_type is
1610: select nvl(amort_inc_adj_rev_dt_yn, 'N')
1611: from okl_sys_acct_opts;
1612:
1613: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
1614:
1615: BEGIN

Line 1789: from okl_sys_acct_opts;

1785:
1786: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
1787: cursor get_rebook_type is
1788: select nvl(amort_inc_adj_rev_dt_yn, 'N')
1789: from okl_sys_acct_opts;
1790:
1791: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
1792: BEGIN
1793: l_return_status := G_RET_STS_SUCCESS;

Line 2001: from okl_sys_acct_opts;

1997:
1998: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
1999: cursor get_rebook_type is
2000: select nvl(amort_inc_adj_rev_dt_yn, 'N')
2001: from okl_sys_acct_opts;
2002:
2003: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
2004:
2005:

Line 2231: from okl_sys_acct_opts;

2227:
2228: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
2229: cursor get_rebook_type is
2230: select nvl(amort_inc_adj_rev_dt_yn, 'N')
2231: from okl_sys_acct_opts;
2232:
2233: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
2234:
2235: BEGIN