DBA Data[Home] [Help]

APPS.PN_VAR_RENTS_PKG dependencies on DUAL

Line 81: FROM dual;

77: -------------------------------------------------------
78: IF ( X_VAR_RENT_ID IS NULL) THEN
79: SELECT pn_var_rents_s.nextval
80: INTO X_VAR_RENT_ID
81: FROM dual;
82: END IF;
83:
84: -- If rent_num is null then copy var_rent_id into rent_num.
85: IF (X_RENT_NUM IS NULL) THEN

Line 690: FROM dual

686: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.check_UNIQUE_rent_number (+)');
687:
688: SELECT 1
689: INTO l_dummy
690: FROM dual
691: WHERE not exists
692: (
693: SELECT 1
694: FROM pn_var_rents_all pnvr