APPS.CSD_RULES_ENGINE_PVT dependencies on OKC_K_LINES_B

Line 2369: FROM OKC_K_Lines_B

2365: -- has passed. If either date is null, do not consider it as a valid date for.
2366: -- comparison. If both end and termination dates are null, then return null.
2367: CURSOR cur_get_contract_end_date(p_contract_line_id NUMBER) IS
2368: SELECT least(nvl(end_date, date_terminated), nvl(date_terminated, end_date))
2369: FROM OKC_K_Lines_B
2370: WHERE id = p_contract_line_id
2371: ;
2372:
2373: BEGIN

Line 2639: || ' from okc_k_lines_b okl'

2635: -- bug 7323831 - contract line can expire if either end date or termination date
2636: -- has passed. If either date is null, do not consider it as a valid date.
2637: when 'RO_CONTRACT_EXP_THRESHOLD' then
2638: l_join_stmt := 'dra.contract_line_id in (select okl.id'
2639: || ' from okc_k_lines_b okl'
2640: || ' where okl.id = dra.contract_line_id'
2641: || ' AND (least(nvl(end_date, date_terminated), nvl(date_terminated, end_date)) - sysdate)'
2642: -- || ' AND (okl.end_date - sysdate) '
2643: || l_num_condition || ')';