eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKC_ANCESTRYS

Line 232: where k_line_id in (select cle_id_ascendant from okc_ancestrys

228:
229: CURSOR c_dates IS
230: select max(start_date), min(end_date)
231: from oke_k_lines_v
232: where k_line_id in (select cle_id_ascendant from okc_ancestrys
233: where cle_id = p_line_id) ;
234:
235:
236: l_start DATE;

Line 354: select cle_id from okc_ancestrys

350: select start_date, end_date
351: from oke_k_lines_v
352: where k_line_id in
353: (
354: select cle_id from okc_ancestrys
355: where cle_id_ascendant=l_id
356: );
357: child_rec child_cursor%ROWTYPE;
358: