APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on OKC_K_LINES_B

Line 291: SELECT 'x' from okc_k_lines_b OKCL, ahl_unit_effectivities_b UE

287: l_scheduled_date DATE;
288:
289: -- Cursor to check whether contract for exiting UE is valid(bug#4692366)
290: CURSOR valid_contract_csr (p_unit_effectivity_id IN NUMBER) IS
291: SELECT 'x' from okc_k_lines_b OKCL, ahl_unit_effectivities_b UE
292: --WHERE NVL(NVL(DATE_TERMINATED,END_DATE),SYSDATE) >= SYSDATE
293: -- Fix for bug# 5517930
294: WHERE NVL(NVL(DATE_TERMINATED,END_DATE),SYSDATE+1) >= trunc(SYSDATE)
295: AND OKCL.id = UE.service_line_id

Line 303: FROM okc_k_lines_b OKCL, ahl_unit_effectivities_b UE

299: -- delete UMP rows only if due date > termination date/end date.
300: CURSOR valid_due_date_csr (p_unit_effectivity_id IN NUMBER,
301: p_due_date IN DATE) IS
302: SELECT 'x'
303: FROM okc_k_lines_b OKCL, ahl_unit_effectivities_b UE
304: WHERE trunc(p_due_date) <= NVL(DATE_TERMINATED,END_DATE)
305: AND OKCL.id = UE.service_line_id
306: AND UE.unit_effectivity_id = p_unit_effectivity_id;
307: