439: END IF;
440:
441: SELECT agreement_id
442: INTO l_agreement_id
443: FROM oe_agreements_vl
444: WHERE name = (select name from oe_agreements_vl
445: where
446: agreement_id = p_x_line_rec.agreement_id)
447: AND trunc(nvl(p_x_line_rec.pricing_date,sysdate)) BETWEEN
440:
441: SELECT agreement_id
442: INTO l_agreement_id
443: FROM oe_agreements_vl
444: WHERE name = (select name from oe_agreements_vl
445: where
446: agreement_id = p_x_line_rec.agreement_id)
447: AND trunc(nvl(p_x_line_rec.pricing_date,sysdate)) BETWEEN
448: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))