DBA Data[Home] [Help]

APPS.OKC_TIME_RES_PVT dependencies on OKC_SPAN

Line 839: FROM Okc_Span

835: p_cutoff_date IN date) IS
836: CURSOR okc_spn_csr (p_id IN NUMBER)
837: IS
838: SELECT id, active_yn, duration, uom_code
839: FROM Okc_Span
840: connect by prior id = spn_id
841: start with ((spn_id is NULL) or (spn_id = OKC_API.G_MISS_NUM)) and
842: tve_id = p_id;
843: type l_okc_spn_tbl_type is table of okc_spn_csr%ROWTYPE index by binary_integer;