DBA Data[Home] [Help]

APPS.OKL_ISG_UTILS_PVT dependencies on OKL_K_LINES

Line 580: from okl_k_lines_full_v kle,

576: kle.fee_type,
577: kle.initial_direct_cost,
578: tl.item_description,
579: tl.name
580: from okl_k_lines_full_v kle,
581: okc_line_styles_b lse,
582: okc_k_lines_tl tl,
583: okc_statuses_b sts
584: where KLE.LSE_ID = LSE.ID

Line 638: okl_k_lines kle

634: FROM okc_rules_b rul,
635: okc_rules_b rul2,
636: okc_rule_groups_b rgp,
637: okc_k_lines_b cle,
638: okl_k_lines kle
639: WHERE rgp.dnz_chr_id = p_khr_id
640: AND rgp.cle_id = cle.id
641: AND kle.id = p_kle_id
642: AND cle.sts_code IN ('PASSED', 'COMPLETE')

Line 656: FROM okl_k_lines

652: -- cursoer to get initial direct cost
653:
654: CURSOR c_fee_idc (p_kle_id NUMBER) IS
655: SELECT NVL(initial_direct_cost, 0)
656: FROM okl_k_lines
657: WHERE id = p_kle_id;
658:
659:
660: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_STRM_GEN_TEMPLATE';