APPS.OKS_CONTRACTS_PUB dependencies on OKC_K_LINES_V

Line 35: SELECT Start_Date, End_Date From OKC_K_LINES_V

31: x_status OUT NOCOPY VarChar2
32: )
33: IS
34: CURSOR l_line_csr Is
35: SELECT Start_Date, End_Date From OKC_K_LINES_V
36: WHERE id = p_cle_id;
37:
38: l_line_csr_rec l_line_csr%ROWTYPE;
39: l_msg_data Varchar2(2000);

Line 2747: From OKC_K_LINES_V KL

2743: ) Return Number Is
2744:
2745: Cursor l_Service_Csr Is
2746: Select KL.Id Cle_Id
2747: From OKC_K_LINES_V KL
2748: ,OKC_K_ITEMS_V KI
2749: Where KL.dnz_chr_id = p_ChrId
2750: And KL.lse_id In (14, 19)
2751: And KL.Id = KI.cle_Id

Line 5352: okc_k_lines_v kc

5348: , ks.usage_type
5349: --, ks.rule_information10
5350: , ks.base_reading
5351: From oks_k_lines_b ks,
5352: okc_k_lines_v kc
5353: Where ks.cle_id = kc.id
5354: And kc.lse_id = 12;
5355:
5356: l_rule_dtl_rec l_rule_dtl_csr%rowtype;