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