DBA Data[Home] [Help]

APPS.PN_LANDLORD_SERVICES_PKG dependencies on DUAL

Line 95: FROM DUAL;

91: -------------------------------------------------------*/
92: IF ( x_landlord_service_id IS NULL) THEN
93: SELECT pn_landlord_services_s.NEXTVAL
94: INTO x_landlord_service_id
95: FROM DUAL;
96: END IF;
97:
98: INSERT INTO pn_landlord_services_all
99: (

Line 500: FROM DUAL;

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
503: (
504: LANDLORD_SERVICE_HISTORY_ID,