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 4285: from okc_k_lines_v

4281: ,x_msg_tbl IN OUT NOCOPY attr_msg_tbl_type) IS
4282:
4283: Cursor cur_line_dates(p_cle_id in NUMBER) is
4284: select start_date , end_date, lse_id
4285: from okc_k_lines_v
4286: where id = p_cle_id;
4287: line_dates_rec cur_line_dates%ROWTYPE;
4288:
4289: Cursor cur_okc_lines(p_cle_id in NUMBER) is

Line 4315: from okc_k_lines_v

4311:
4312:
4313: Cursor cur_sub_line(p_cle_id in NUMBER) IS
4314: select id,lse_id
4315: from okc_k_lines_v
4316: where cle_id =p_cle_id
4317: and chr_id is null
4318: and lse_id in (7,8,9,10,11,13,18,25,35)
4319: and date_cancelled is null; --[llc]

Line 4328: from okc_k_lines_v

4324: select id,
4325: lse_id,
4326: line_number,
4327: date_terminated -- new
4328: from okc_k_lines_v
4329: where id =p_subline_id;
4330:
4331: l_sub_line_lse_rec cur_sub_line_lse%ROWTYPE;
4332: