511: -- validate foreign keys
512: if cr.PLANNER_CODE is not null then
513: begin
514: select 'x' into temp 515: from MTL_PLANNERS 516: where PLANNER_CODE = cr.PLANNER_CODE
517: and ORGANIZATION_ID = cr.ORGANIZATION_ID
518: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/
519: exception