APPS.OE_VALIDATE_HEADER dependencies on OE_AGREEMENTS_V

Line 1481: from oe_agreements_vl

1477: BEGIN
1478: --bug 5206956 added sold_to_org_id in the next 2 selects
1479: select name,revision, sold_to_org_id
1480: into l_agreement_name,l_agreement_revision, l_sold_to_org
1481: from oe_agreements_vl
1482: where agreement_id = p_header_rec.agreement_id;
1483:
1484: select name,revision, sold_to_org_id
1485: into l_agreement_name,l_agreement_revision, l_sold_to_org

Line 1486: from oe_agreements_vl

1482: where agreement_id = p_header_rec.agreement_id;
1483:
1484: select name,revision, sold_to_org_id
1485: into l_agreement_name,l_agreement_revision, l_sold_to_org
1486: from oe_agreements_vl
1487: where agreement_id = p_header_rec.agreement_id
1488: AND trunc(nvl(p_header_rec.pricing_date,sysdate)) between
1489: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
1490: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));

Line 1541: from oe_agreements_v

1537: -- be associated with any agreement according to bug 1386406.
1538:
1539: select name ,sold_to_org_id , price_list_id
1540: into l_agreement_name,l_sold_to_org,l_price_list_id
1541: from oe_agreements_v
1542: where agreement_id = p_header_rec.agreement_id
1543: AND trunc(nvl(p_header_rec.pricing_date,sysdate)) between
1544: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
1545: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));