DBA Data[Home] [Help]

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,