1556: THEN
1557: BEGIN
1558: select memo_line_id
1559: into x_memo_line_id
1560: from ar_memo_lines
1561: where line_type='LINE' and
1562: sysdate between nvl(trunc(start_date),sysdate)
1563: and nvl(trunc(end_date),sysdate) and
1564: name = p_memo_line_name;
1579:
1580: BEGIN
1581: select memo_line_id
1582: into l_dummy
1583: from ar_memo_lines
1584: where line_type='LINE' and
1585: sysdate between nvl(trunc(start_date),sysdate)
1586: and nvl(trunc(end_date),sysdate) and
1587: memo_line_id = x_memo_line_id;