APPS.PN_LANDLORD_SERVICES_PKG dependencies on PN_LANDLORD_SERVICE_HISTORY
Line 498: SELECT PN_LANDLORD_SERVICE_HISTORY_S.NEXTVAL
494: CLOSE c2;
495:
496: IF (recInfoForHist.LEASE_CHANGE_ID <> X_LEASE_CHANGE_ID) THEN
497: 498: SELECT PN_LANDLORD_SERVICE_HISTORY_S.NEXTVAL 499: INTO l_llserviceHistoryId
500: FROM DUAL;
501:
502: INSERT INTO PN_LANDLORD_SERVICE_HISTORY
Line 502: INSERT INTO PN_LANDLORD_SERVICE_HISTORY
498: SELECT PN_LANDLORD_SERVICE_HISTORY_S.NEXTVAL
499: INTO l_llserviceHistoryId
500: FROM DUAL;
501: 502: INSERT INTO PN_LANDLORD_SERVICE_HISTORY 503: (
504: LANDLORD_SERVICE_HISTORY_ID,
505: LANDLORD_SERVICE_ID,
506: LAST_UPDATE_DATE,