[Home] [Help]
1468: TRUNC(NVL(end_date_active, SYSDATE));
1469:
1470: cursor cur_sr_group_def_staus_id(p_status_group_id number) is
1471: select default_incident_status_id
1472: from cs_sr_status_groups_b
1473: where status_group_id = p_status_group_id
1474: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date, SYSDATE)) AND
1475: TRUNC(NVL(end_date, SYSDATE));
1476: