APPS.OKC_EXTEND_PVT dependencies on OKC_K_LINES_V

Line 416: FROM okc_k_lines_v cle,

412: -- bug # 5757116 added trunc in the where clause of the cursor.
413: CURSOR cur_k_lines is
414: SELECT cle.line_number,cle.item_description,cle.id,cle.lse_id,cle.sts_code,cle.dnz_chr_id,
415: cle.object_version_number,cle.date_terminated,cle.end_date,sts.ste_code
416: FROM okc_k_lines_v cle,
417: okc_statuses_b sts
418: WHERE cle.id = p_extend_in_parameters_rec.p_cle_id
419: AND trunc(cle.end_date) = trunc(p_extend_in_parameters_rec.p_orig_end_date)
420: AND cle.sts_code = sts.code;

Line 1180: FROM okc_k_lines_v

1176: rec_k_header OKC_CONTRACT_PUB.chrv_rec_type;
1177:
1178: CURSOR lock_lines is
1179: SELECT *
1180: FROM okc_k_lines_v
1181: WHERE dnz_chr_id = p_extend_in_parameters_rec.p_contract_id
1182: FOR update of line_number nowait;
1183:
1184: CURSOR lock_rules is

Line 1541: l_kl_sts_code okc_k_lines_v.sts_code%type;

1537: AND k.scs_code = scs.code;
1538:
1539: l_contract_number okc_k_headers_v.contract_number%type;
1540: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1541: l_kl_sts_code okc_k_lines_v.sts_code%type;
1542: l_scs_code okc_subclasses_v.code%type;
1543: l_cls_code okc_subclasses_v.cls_code%type;
1544: l_price_negotiated number;
1545: i_cle_rec okc_contract_pub.clev_rec_type;

Line 1575: From OKC_K_LINES_V

1571:
1572:
1573: Cursor LineCov_cur(p_cle_id IN Number) Is
1574: Select id
1575: From OKC_K_LINES_V
1576: Where cle_id = p_cle_id
1577: and lse_id in (2,13,15,20);
1578: BEGIN
1579: