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