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 3966: FROM okc_k_headers_b contract, okc_k_lines_b line

3962: IS
3963:
3964: CURSOR l_line_cur IS
3965: SELECT contract.currency_code
3966: FROM okc_k_headers_b contract, okc_k_lines_b line
3967: WHERE contract.id = line.dnz_chr_id and line.id = p_cle_id;
3968:
3969: CURSOR l_hdr_cur IS
3970: SELECT contract.currency_code

Line 3971: FROM okc_k_headers_b contract

3967: WHERE contract.id = line.dnz_chr_id and line.id = p_cle_id;
3968:
3969: CURSOR l_hdr_cur IS
3970: SELECT contract.currency_code
3971: FROM okc_k_headers_b contract
3972: WHERE contract.id = p_chr_id;
3973:
3974:
3975: l_Currency VARCHAR2(15);

Line 4641: FROM OKC_K_HEADERS_b

4637: IS
4638:
4639: Cursor l_hdr_Csr Is
4640: SELECT id, TRUNC(start_date) start_dt, TRUNC(end_date) end_dt
4641: FROM OKC_K_HEADERS_b
4642: WHERE id = p_hdr_id ;
4643:
4644:
4645: CURSOR l_Sll_Csr IS

Line 10548: FROM okc_k_headers_b hdr, oks_k_headers_b dtl

10544: Cursor l_contract_Csr Is
10545: SELECT hdr.id, TRUNC(hdr.start_date) start_dt,
10546: nvl(trunc(hdr.date_terminated - 1) ,TRUNC(hdr.end_date)) end_dt,
10547: hdr.inv_rule_id inv_rule_id, dtl.billing_schedule_type billing_schedule_type
10548: FROM okc_k_headers_b hdr, oks_k_headers_b dtl
10549: WHERE hdr.id = dtl.chr_id
10550: AND hdr.Id = p_contract_id ;
10551:
10552: