2515: CURSOR c_access IS
2516: select distinct role_id,person_id,
2517: decode(sign(trunc(start_date_active)-trunc(sysdate)),1,trunc(start_date_active),trunc(sysdate)),
2518: trunc(end_date_active) 2519: from oke_k_access_v 2520: where object_id=p_source_k_header_id
2521: and (end_date_active is null OR trunc(end_date_active)> trunc(sysdate));
2522:
2523: