APPS.PN_CONTACT_ASSIGNMENTS_PKG dependencies on PN_CONTACT_ASSIGN_HISTORY
Line 384: SELECT pn_contact_assign_hIStory_s.nextval
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
Line 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