APPS.CSD_RULES_ENGINE_PVT dependencies on OKC_K_LINES_B

Line 1797: FROM OKC_K_Lines_B

1793: -- has passed. If either date is null, do not consider it as a valid date for.
1794: -- comparison. If both end and termination dates are null, then return null.
1795: CURSOR cur_get_contract_end_date(p_contract_line_id NUMBER) IS
1796: SELECT least(nvl(end_date, date_terminated), nvl(date_terminated, end_date))
1797: FROM OKC_K_Lines_B
1798: WHERE id = p_contract_line_id
1799: ;
1800:
1801: BEGIN

Line 2067: || ' from okc_k_lines_b okl'

2063: -- bug 7323831 - contract line can expire if either end date or termination date
2064: -- has passed. If either date is null, do not consider it as a valid date.
2065: when 'RO_CONTRACT_EXP_THRESHOLD' then
2066: l_join_stmt := 'dra.contract_line_id in (select okl.id'
2067: || ' from okc_k_lines_b okl'
2068: || ' where okl.id = dra.contract_line_id'
2069: || ' AND (least(nvl(end_date, date_terminated), nvl(date_terminated, end_date)) - sysdate)'
2070: -- || ' AND (okl.end_date - sysdate) '
2071: || l_num_condition || ')';