DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on OE_AGREEMENTS_VL

Line 6500: FROM oe_agreements_vl

6496: END IF;
6497:
6498: SELECT name
6499: INTO l_agreement_name
6500: FROM oe_agreements_vl
6501: WHERE agreement_id = p_line_rec.agreement_id
6502: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) BETWEEN
6503: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6504: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));