[Home] [Help]
1532: oec,
1533: e.ste_code ste_code -- 5264170
1534: FROM OKL_K_LINES a,
1535: OKC_K_LINES_TL b,
1536: OKC_LINE_STYLES_V C,
1537: OKC_K_LINES_B d,
1538: OKC_STATUSES_B e
1539: WHERE a.ID = p_id
1540: AND a.ID = b.ID
3140: --2. Check the disb amt not exceed line payment amt --
3141: -- Find out lines for a contract
3142: CURSOR lines_csr(p_chr_id IN NUMBER) IS
3143: SELECT cle.id,cle.name,lse.lty_code
3144: FROM okl_k_lines_full_v cle, okc_line_styles_v lse
3145: WHERE cle.dnz_chr_id = p_chr_id
3146: AND cle.lse_id = lse.id
3147: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');
3148:
3266: pph.passthru_start_date,
3267: pph.passthru_term,
3268: pph.passthru_stream_type_id
3269: FROM okl_k_lines_full_v line,
3270: okc_line_styles_v style,
3271: okc_statuses_v sts,
3272: okl_party_payment_hdr pph
3273: WHERE line.lse_id = style.id
3274: AND line.sts_code = sts.code
3304: line.fee_type,
3305: rule.object1_id1,
3306: style.name line_style
3307: FROM okl_k_lines_full_v line,
3308: okc_line_styles_v style,
3309: okc_statuses_v sts,
3310: okc_rule_groups_b rgp,
3311: okc_rules_b rule
3312: WHERE rgp.id = rule.rgp_id
4078: 'Y' stub_only
4079: FROM okc_rules_b rule,
4080: okc_rule_groups_b rgp,
4081: okc_k_lines_b line,
4082: okc_line_styles_v style,
4083: okc_statuses_b sts
4084: WHERE rgp.id = rule.rgp_id
4085: AND rgp.rgd_code = 'LALEVL'
4086: AND rgp.dnz_chr_id = p_chr_id
5397: l.amount,
5398: l.capital_amount,
5399: l.fee_type
5400: FROM okl_k_lines_full_v l,
5401: okc_line_styles_v sty,
5402: okc_statuses_v sts
5403: WHERE l.lse_id = sty.id
5404: AND l.sts_code = sts.code
5405: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
6633: ls.name line_type,
6634: kle.id,
6635: kle.name
6636: FROM OKL_K_LINES_FULL_V kle,
6637: OKC_LINE_STYLES_V ls,
6638: OKC_STATUSES_B sts
6639: WHERE kle.lse_id = ls.id
6640: AND ls.lty_code IN ('FREE_FORM1', 'FEE', 'SOLD_SERVICE')
6641: AND kle.dnz_chr_id = chrid
7700: AND status = 'A'
7701: AND TRUNC(SYSDATE) >= NVL(TRUNC(start_date_active), TRUNC(SYSDATE));
7702:
7703: CURSOR line_amt_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
7704: p_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
7705: SELECT line.id,
7706: line.line_number,
7707: line.amount
7708: FROM okl_k_lines_full_v line,
7705: SELECT line.id,
7706: line.line_number,
7707: line.amount
7708: FROM okl_k_lines_full_v line,
7709: okc_line_styles_v style,
7710: okc_statuses_b sts
7711: WHERE line.lse_id = style.id
7712: AND style.lty_code = p_lty_code
7713: AND sts.code = line.sts_code
7821: SELECT NVL(kle.name,kle.item_description) name,
7822: kle.id,
7823: ls.name line_style
7824: FROM OKL_K_LINES_FULL_V kle,
7825: OKC_LINE_STYLES_v ls,
7826: OKC_STATUSES_B sts
7827: WHERE kle.lse_id = ls.id
7828: AND ls.lty_code = ltycode
7829: AND kle.dnz_chr_id = chrid
7842: -- cursor to fecth link line id for top line id
7843: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
7844: SELECT kle.id
7845: FROM OKL_K_LINES_FULL_V kle,
7846: OKC_LINE_STYLES_v ls,
7847: OKC_STATUSES_B sts
7848: WHERE kle.lse_id = ls.id
7849: AND ls.lty_code = ltycode
7850: AND kle.dnz_chr_id = chrid
10607: strm.code strm_type
10608: FROM okl_k_lines_full_v line,
10609: okc_k_items item,
10610: okl_strmtyp_source_v strm,
10611: okc_line_styles_v style,
10612: okc_statuses_b sts
10613: WHERE line.dnz_chr_id = p_chr_id
10614: AND line.lse_id = style.id
10615: AND line.sts_code = sts.code
11015: CURSOR asset_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
11016: SELECT line.id,
11017: line.name
11018: FROM okl_k_lines_full_v line,
11019: okc_line_styles_v style,
11020: okc_statuses_b sts
11021: WHERE line. dnz_chr_id = p_chr_id
11022: AND line.lse_id = style.id
11023: AND style.lty_code = 'FREE_FORM1'
11804: CURSOR l_lne_csr (p_chr_id NUMBER) IS
11805: SELECT lne.id id,
11806: style.name line_type
11807: FROM okc_k_lines_b lne,
11808: okc_line_styles_v style
11809: WHERE dnz_chr_id = p_chr_id
11810: AND style.id = lne.lse_id;
11811:
11812: -- R12B Authoring OA Migration
11817: SELECT cle.id,
11818: style.name line_type
11819: FROM okl_k_lines kle,
11820: okc_k_lines_b cle,
11821: okc_line_styles_v style
11822: WHERE cle.dnz_chr_id = p_chr_id
11823: AND cle.id = kle.id
11824: AND cle.lse_id = style.id
11825: AND kle.fee_type = 'FINANCED'