APPS.OKS_BILL_SCH dependencies on OKC_K_HEADERS_ALL_B

Line 3080: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;

3076: l_tce_code VARCHAR2(100);
3077: l_constant_sll_amt NUMBER;
3078: l_remaining_amt NUMBER;
3079: l_dummy_top_line_bs oks_bill_level_elements_pvt.letv_tbl_type;
3080: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;
3081: ------------------------------------------------------------------------
3082: -- Begin partial period computation logic
3083: -- Developer Mani Choudhary
3084: -- Date 17-MAY-2005

Line 3540: FROM OKC_K_HEADERS_ALL_B

3536: l_lvl_ele_tbl_in(l_tbl_seq).date_to_interface := TRUNC(l_fnd_lvl_out_rec.date_to_interface);
3537:
3538: SELECT nvl(BILLED_AT_SOURCE , 'N')
3539: INTO l_billed_at_source
3540: FROM OKC_K_HEADERS_ALL_B
3541: WHERE id = p_line_rec.dnz_chr_id;
3542:
3543: if l_billed_at_source = 'Y' Then
3544: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := sysdate;

Line 9412: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;

9408: l_term_amt NUMBER;
9409: l_compare_dt DATE;
9410: i number;
9411: l_end_date DATE;
9412: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;
9413: --
9414: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
9415: l_return_status VARCHAR2(1);
9416: l_msg_count NUMBER;

Line 10109: FROM OKC_K_HEADERS_ALL_B

10105: l_lvl_ele_tbl_in(l_tbl_seq).date_to_interface := TRUNC(l_fnd_lvl_out_rec.date_to_interface);
10106:
10107: SELECT nvl(BILLED_AT_SOURCE , 'N')
10108: INTO l_billed_at_source
10109: FROM OKC_K_HEADERS_ALL_B
10110: WHERE id = p_Line_rec.dnz_chr_id;
10111:
10112: if l_billed_at_source = 'Y' Then
10113: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := sysdate;