APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKC_K_LINES_V

Line 452: From OKC_K_LINES_V

448: line_dates_rec cur_line_dates%ROWTYPE;
449:
450: Cursor LineCov_cur(p_cle_id IN Number) Is
451: Select id
452: From OKC_K_LINES_V
453: Where cle_id = p_cle_id
454: and lse_id in (2,13,15,20);
455:
456: Cursor cur_okc_headers(p_chr_id in NUMBER) is

Line 575: from okc_k_lines_v

571: -- Bug 4717842 --
572: -- Ignore the cancelled lines.
573: Cursor cur_sub_line(l_cle_id number) IS
574: select id, price_negotiated, cle_id, price_unit
575: from okc_k_lines_v
576: where lse_id in (7,8,9,10,11,13,18,25,35)
577: and date_cancelled is NULL -- new
578: and cle_id = l_cle_id;
579: -- Bug 4717842 --

Line 718: from okc_k_lines_v

714: AND DNZ_CHR_ID = p_chr_id;
715:
716: Cursor cur_get_line_number(p_cle_id in NUMBER, p_chr_id IN NUMBER) IS
717: Select line_number
718: from okc_k_lines_v
719: where cle_id =p_cle_id
720: and dnz_chr_id = p_chr_id;
721:
722:

Line 4213: from okc_k_lines_v

4209: ,x_msg_tbl IN OUT NOCOPY attr_msg_tbl_type) IS
4210:
4211: Cursor cur_line_dates(p_cle_id in NUMBER) is
4212: select start_date , end_date, lse_id
4213: from okc_k_lines_v
4214: where id = p_cle_id;
4215: line_dates_rec cur_line_dates%ROWTYPE;
4216:
4217: Cursor cur_okc_lines(p_cle_id in NUMBER) is

Line 4243: from okc_k_lines_v

4239:
4240:
4241: Cursor cur_sub_line(p_cle_id in NUMBER) IS
4242: select id,lse_id
4243: from okc_k_lines_v
4244: where cle_id =p_cle_id
4245: and chr_id is null
4246: and lse_id in (7,8,9,10,11,13,18,25,35)
4247: and date_cancelled is null; --[llc]

Line 4256: from okc_k_lines_v

4252: select id,
4253: lse_id,
4254: line_number,
4255: date_terminated -- new
4256: from okc_k_lines_v
4257: where id =p_subline_id;
4258:
4259: l_sub_line_lse_rec cur_sub_line_lse%ROWTYPE;
4260: