APPS.OE_VALIDATE_LINE dependencies on OE_AGREEMENTS_V

Line 6403: FROM oe_agreements_v

6399:
6400: BEGIN
6401: SELECT name ,sold_to_org_id , price_list_id
6402: INTO l_agreement_name,l_sold_to_org,l_price_list_id
6403: FROM oe_agreements_v
6404: WHERE agreement_id = p_line_rec.agreement_id
6405: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) between
6406: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6407: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));

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)));