DBA Data[Home] [Help]

APPS.OE_DEFAULT_LINE dependencies on OE_AGREEMENTS_VL

Line 441: FROM oe_agreements_vl

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

Line 442: WHERE name = (select name from oe_agreements_vl

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