[Home] [Help]
366: BEGIN
367:
368: -- Insert child values
369:
370: INSERT INTO QA_PLAN_CHAR_VALUE_LOOKUPS (
371: PLAN_ID,
372: CHAR_ID,
373: SHORT_CODE,
374: LAST_UPDATE_DATE,
386: SYSDATE,
387: X_USER_ID,
388: DESCRIPTION,
389: SHORT_CODE_ID
390: FROM QA_PLAN_CHAR_VALUE_LOOKUPS
391: WHERE PLAN_ID = X_COPY_PLAN_ID
392: AND CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS
393: WHERE PLAN_ID = X_PLAN_ID);
394: