APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on OKC_K_LINES_B

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

352: l_scheduled_date DATE;
353:
354: -- Cursor to check whether contract for exiting UE is valid(bug#4692366)
355: CURSOR valid_contract_csr (p_unit_effectivity_id IN NUMBER) IS
356: SELECT 'x' from okc_k_lines_b OKCL, ahl_unit_effectivities_b UE
357: --WHERE NVL(NVL(DATE_TERMINATED,END_DATE),SYSDATE) >= SYSDATE
358: -- Fix for bug# 5517930
359: WHERE NVL(NVL(DATE_TERMINATED,END_DATE),SYSDATE+1) >= trunc(SYSDATE)
360: AND OKCL.id = UE.service_line_id

Line 368: FROM okc_k_lines_b OKCL, ahl_unit_effectivities_b UE

364: -- delete UMP rows only if due date > termination date/end date.
365: CURSOR valid_due_date_csr (p_unit_effectivity_id IN NUMBER,
366: p_due_date IN DATE) IS
367: SELECT 'x'
368: FROM okc_k_lines_b OKCL, ahl_unit_effectivities_b UE
369: WHERE trunc(p_due_date) <= NVL(DATE_TERMINATED,END_DATE)
370: AND OKCL.id = UE.service_line_id
371: AND UE.unit_effectivity_id = p_unit_effectivity_id;
372: