APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKC_K_LINES_B

Line 82: FROM OKC_K_LINES_B

78:
79: CURSOR L_GET_TOP_LINE_DATES_CSR(P_TOP_LINE_ID IN NUMBER ) IS
80: SELECT TRUNC(START_DATE) START_DATE
81: , TRUNC(END_DATE) END_DATE
82: FROM OKC_K_LINES_B
83: WHERE ID = P_TOP_LINE_ID;
84:
85: L_GET_TOP_LINE_DATES_REC L_GET_TOP_LINE_DATES_CSR%ROWTYPE;
86:

Line 446: from okc_k_lines_b

442: Cursor cur_line_dates(p_cle_id in NUMBER) is
443: select start_date,
444: end_date,
445: lse_id
446: from okc_k_lines_b
447: where id = p_cle_id;
448: line_dates_rec cur_line_dates%ROWTYPE;
449:
450: Cursor LineCov_cur(p_cle_id IN Number) Is

Line 484: from okc_k_lines_b

480: lse_id,
481: price_negotiated,
482: bill_to_site_use_id,
483: ship_to_site_use_id
484: from okc_k_lines_b
485: where id = p_cle_id;
486: l_okc_lines_rec cur_okc_lines%ROWTYPE;
487:
488: Cursor cur_oks_headers(p_chr_id in NUMBER) is

Line 561: from okc_k_lines_b

557: where id1=p_object1_id1;
558:
559: Cursor cur_line_cust_acct(p_cle_id IN NUMBER) IS
560: select cust_acct_id
561: from okc_k_lines_b
562: where id =p_cle_id;
563: --commenting out, because it is not beeing used any where, 05/04/2004
564: --Cursor line_contact(p_contact_id in number ) IS
565: -- select * from okc_contacts

Line 613: from cs_incidents_all_b cs , okc_k_lines_b line

609: select distinct incident_id,
610: contract_number,
611: contract_service_id,
612: incident_number
613: from cs_incidents_all_b cs , okc_k_lines_b line
614: where cs.contract_service_id = p_cle_id
615: and cs.contract_id =p_chr_id
616: and cs.contract_id =line.dnz_chr_id
617: and line.cle_id = p_cle_id

Line 651: from okc_k_lines_b

647: group by id;
648:
649: Cursor cur_line_number(p_cle_id IN VARCHAR2) Is
650: select line_number
651: from okc_k_lines_b
652: where id = p_cle_id;
653: ----new
654: Cursor cur_cust_acct_id(p_chr_id in NUMBER,
655: p_billto_id in NUMBER) is

Line 732: from oks_k_lines_b oks, okc_k_lines_b okc

728: cust_po_number,
729: cust_po_number_req_yn,
730: payment_instruction_type,
731: trxn_extension_id
732: from oks_k_lines_b oks, okc_k_lines_b okc
733: where okc.id = p_cle_id
734: and oks.cle_id = okc.id;
735: -- END GCHADHA --
736:

Line 772: from okc_k_lines_b cle, oks_k_lines_b sle

768: -- Recalculate Tax --
769: -- Bug 4717842 --
770: CURSOR get_topline_tax_amt_csr (p_cle_id IN NUMBER) IS
771: Select nvl(sum(nvl(tax_amount,0)),0) tax_amount
772: from okc_k_lines_b cle, oks_k_lines_b sle
773: where cle.cle_id = p_cle_id
774: and cle.lse_id in (7,8,9,10,11,13,25,35)
775: and cle.id = sle.cle_id
776: and cle.dnz_chr_id = sle.dnz_chr_id

Line 781: from okc_k_lines_b cle, oks_k_lines_b sle

777: and cle.date_cancelled is null;
778:
779: Cursor get_hdr_tax_amt_csr (p_chr_id in number) IS
780: Select nvl(sum(nvl(tax_amount,0)),0) tax_amount
781: from okc_k_lines_b cle, oks_k_lines_b sle
782: where cle.chr_id = p_chr_id
783: and cle.id = sle.cle_id
784: and cle.dnz_chr_id = sle.dnz_chr_id
785: and cle.date_cancelled is null;

Line 4222: from okc_k_lines_b

4218: select
4219: id,
4220: line_number,
4221: line_renewal_type_code
4222: from okc_k_lines_b
4223: where id = p_cle_id;
4224: l_okc_lines_rec cur_okc_lines%ROWTYPE;
4225:
4226: Cursor cur_oks_lines(p_cle_id in NUMBER) is