APPS.OKS_BILL_SCH dependencies on OKC_K_HEADERS_ALL_B

Line 3097: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;

3093: l_tce_code VARCHAR2(100);
3094: l_constant_sll_amt NUMBER;
3095: l_remaining_amt NUMBER;
3096: l_dummy_top_line_bs oks_bill_level_elements_pvt.letv_tbl_type;
3097: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;
3098: ------------------------------------------------------------------------
3099: -- Begin partial period computation logic
3100: -- Developer Mani Choudhary
3101: -- Date 17-MAY-2005

Line 3557: FROM OKC_K_HEADERS_ALL_B

3553: l_lvl_ele_tbl_in(l_tbl_seq).date_to_interface := TRUNC(l_fnd_lvl_out_rec.date_to_interface);
3554:
3555: SELECT nvl(BILLED_AT_SOURCE , 'N')
3556: INTO l_billed_at_source
3557: FROM OKC_K_HEADERS_ALL_B
3558: WHERE id = p_line_rec.dnz_chr_id;
3559:
3560: if l_billed_at_source = 'Y' Then
3561: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := sysdate;

Line 9625: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;

9621: l_term_amt NUMBER;
9622: l_compare_dt DATE;
9623: i number;
9624: l_end_date DATE;
9625: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;
9626: --
9627: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
9628: l_return_status VARCHAR2(1);
9629: l_msg_count NUMBER;

Line 10352: FROM OKC_K_HEADERS_ALL_B

10348: l_lvl_ele_tbl_in(l_tbl_seq).date_to_interface := TRUNC(l_fnd_lvl_out_rec.date_to_interface);
10349:
10350: SELECT nvl(BILLED_AT_SOURCE , 'N')
10351: INTO l_billed_at_source
10352: FROM OKC_K_HEADERS_ALL_B
10353: WHERE id = p_Line_rec.dnz_chr_id;
10354:
10355: if l_billed_at_source = 'Y' Then
10356: l_lvl_ele_tbl_in(l_tbl_seq).date_completed := sysdate;