APPS.OKS_BILL_SCH dependencies on OKC_K_HEADERS_B

Line 797: FROM okc_k_headers_b

793:
794: Cursor l_contract_Csr(l_contract_id number) Is
795: SELECT id, TRUNC(start_date) start_dt,
796: nvl(trunc(date_terminated - 1) ,TRUNC(end_date)) end_dt
797: FROM okc_k_headers_b
798: WHERE Id = l_contract_id ;
799:
800: Cursor l_top_line_Csr(l_contract_id number, l_hdr_date date) Is
801: SELECT line.id id, line.inv_rule_id inv_rule_id, line.lse_id lse_id,

Line 3949: FROM okc_k_headers_b contract, okc_k_lines_b line

3945: IS
3946:
3947: CURSOR l_line_cur IS
3948: SELECT contract.currency_code
3949: FROM okc_k_headers_b contract, okc_k_lines_b line
3950: WHERE contract.id = line.dnz_chr_id and line.id = p_cle_id;
3951:
3952: CURSOR l_hdr_cur IS
3953: SELECT contract.currency_code

Line 3954: FROM okc_k_headers_b contract

3950: WHERE contract.id = line.dnz_chr_id and line.id = p_cle_id;
3951:
3952: CURSOR l_hdr_cur IS
3953: SELECT contract.currency_code
3954: FROM okc_k_headers_b contract
3955: WHERE contract.id = p_chr_id;
3956:
3957:
3958: l_Currency VARCHAR2(15);

Line 4624: FROM OKC_K_HEADERS_b

4620: IS
4621:
4622: Cursor l_hdr_Csr Is
4623: SELECT id, TRUNC(start_date) start_dt, TRUNC(end_date) end_dt
4624: FROM OKC_K_HEADERS_b
4625: WHERE id = p_hdr_id ;
4626:
4627:
4628: CURSOR l_Sll_Csr IS

Line 10305: FROM okc_k_headers_b hdr, oks_k_headers_b dtl

10301: Cursor l_contract_Csr Is
10302: SELECT hdr.id, TRUNC(hdr.start_date) start_dt,
10303: nvl(trunc(hdr.date_terminated - 1) ,TRUNC(hdr.end_date)) end_dt,
10304: hdr.inv_rule_id inv_rule_id, dtl.billing_schedule_type billing_schedule_type
10305: FROM okc_k_headers_b hdr, oks_k_headers_b dtl
10306: WHERE hdr.id = dtl.chr_id
10307: AND hdr.Id = p_contract_id ;
10308:
10309: