[Home] [Help]
380: CLOSE c;
381:
382: IF (recInfoForHist.LEASE_CHANGE_ID <> X_LEASE_CHANGE_ID) THEN
383:
384: SELECT pn_contact_assign_hIStory_s.nextval
385: INTO l_contactHIStoryId
386: FROM DUAL;
387:
388: INSERT INTO PN_CONTACT_ASSIGN_HISTORY
384: SELECT pn_contact_assign_hIStory_s.nextval
385: INTO l_contactHIStoryId
386: FROM DUAL;
387:
388: INSERT INTO PN_CONTACT_ASSIGN_HISTORY
389: (
390: CONTACT_ASSIGN_HISTORY_ID
391: ,CONTACT_ASSIGNMENT_ID
392: ,LAST_UPDATE_DATE