DBA Data[Home] [Help]

APPS.OKL_EXPENSE_STREAMS_PVT dependencies on OKL_K_LINES

Line 20: FROM okl_k_lines kle,

16:
17: CURSOR c_idc_exp IS
18: SELECT kle.id,
19: kle.initial_direct_cost
20: FROM okl_k_lines kle,
21: okc_k_lines_b cle,
22: okc_line_styles_b lse
23: WHERE cle.chr_id = p_khr_id
24: AND cle.sts_code IN ('PASSED', 'COMPLETE')

Line 107: okl_k_lines_full_v kle,

103: sty.stream_type_class stream_type_class
104: from okl_strm_type_tl tl,
105: okl_strm_type_v sty,
106: okc_k_items cim,
107: okl_k_lines_full_v kle,
108: okc_line_styles_b ls
109: where tl.id = sty.id
110: and tl.language = 'US'
111: and cim.cle_id = kle.id

Line 356: okl_k_lines_full_v kle,

352: sty.stream_type_class stream_type_class
353: from okl_strm_type_tl tl,
354: okl_strm_type_v sty,
355: okc_k_items cim,
356: okl_k_lines_full_v kle,
357: okc_line_styles_b ls
358: where tl.id = sty.id
359: and tl.language = 'US'
360: and cim.cle_id = kle.id

Line 383: okl_k_lines kle

379: FROM okc_rules_b rul,
380: okc_rules_b rul2,
381: okc_rule_groups_b rgp,
382: okc_k_lines_b cle,
383: okl_k_lines kle
384: WHERE rgp.dnz_chr_id = p_khr_id
385: AND rgp.cle_id = cle.id
386: AND kle.id = cle.id
387: AND cle.sts_code IN ('NEW', 'INCOMPLETE', 'PASSED', 'COMPLETE')

Line 400: FROM okl_k_lines

396: -- gboomina added for Bug 6763287 - End
397:
398: CURSOR c_fee_idc (p_kle_id NUMBER) IS
399: SELECT NVL(initial_direct_cost, 0)
400: FROM okl_k_lines
401: WHERE id = p_kle_id;
402:
403: l_selv_tbl okl_streams_pub.selv_tbl_type;
404: lx_selv_tbl okl_streams_pub.selv_tbl_type;