APPS.OE_VALIDATE_HEADER dependencies on OE_AGREEMENTS_V

Line 1413: from oe_agreements_vl

1409: BEGIN
1410: --bug 5206956 added sold_to_org_id in the next 2 selects
1411: select name,revision, sold_to_org_id
1412: into l_agreement_name,l_agreement_revision, l_sold_to_org
1413: from oe_agreements_vl
1414: where agreement_id = p_header_rec.agreement_id;
1415:
1416: select name,revision, sold_to_org_id
1417: into l_agreement_name,l_agreement_revision, l_sold_to_org

Line 1418: from oe_agreements_vl

1414: where agreement_id = p_header_rec.agreement_id;
1415:
1416: select name,revision, sold_to_org_id
1417: into l_agreement_name,l_agreement_revision, l_sold_to_org
1418: from oe_agreements_vl
1419: where agreement_id = p_header_rec.agreement_id
1420: AND trunc(nvl(p_header_rec.pricing_date,sysdate)) between
1421: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
1422: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));

Line 1473: from oe_agreements_v

1469: -- be associated with any agreement according to bug 1386406.
1470:
1471: select name ,sold_to_org_id , price_list_id
1472: into l_agreement_name,l_sold_to_org,l_price_list_id
1473: from oe_agreements_v
1474: where agreement_id = p_header_rec.agreement_id
1475: AND trunc(nvl(p_header_rec.pricing_date,sysdate)) between
1476: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
1477: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));