DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on OE_AGREEMENTS_VL

Line 6872: FROM oe_agreements_vl

6868: END IF;
6869:
6870: SELECT name
6871: INTO l_agreement_name
6872: FROM oe_agreements_vl
6873: WHERE agreement_id = p_line_rec.agreement_id
6874: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) BETWEEN
6875: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6876: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));