DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER dependencies on OE_AGREEMENTS_VL

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