DBA Data[Home] [Help]

APPS.OE_DEFAULT_LINE dependencies on OE_AGREEMENTS_VL

Line 443: FROM oe_agreements_vl

439: END IF;
440:
441: SELECT agreement_id
442: INTO l_agreement_id
443: FROM oe_agreements_vl
444: WHERE name = (select name from oe_agreements_vl
445: where
446: agreement_id = p_x_line_rec.agreement_id)
447: AND trunc(nvl(p_x_line_rec.pricing_date,sysdate)) BETWEEN

Line 444: WHERE name = (select name from oe_agreements_vl

440:
441: SELECT agreement_id
442: INTO l_agreement_id
443: FROM oe_agreements_vl
444: WHERE name = (select name from oe_agreements_vl
445: where
446: agreement_id = p_x_line_rec.agreement_id)
447: AND trunc(nvl(p_x_line_rec.pricing_date,sysdate)) BETWEEN
448: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))