DBA Data[Home] [Help]

APPS.IGS_PE_PERS_UNT_EXCL_PKG dependencies on IGS_GE_DATE

Line 82: (NVL(old_references.pue_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

78: BEGIN
79: -- Validate that start date is not less than the current date.
80: IF (new_references.pue_start_dt IS NOT NULL) AND
81: (p_inserting OR (p_updating AND
82: (NVL(old_references.pue_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
83: <> new_references.pue_start_dt)))
84: THEN
85: IF IGS_EN_VAL_PCE.enrp_val_encmb_dt (
86: new_references.pue_start_dt,

Line 109: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

105: -- Validate that if expiry date is specified, then expiry date is not
106: -- less than the start date.
107: IF (new_references.expiry_dt IS NOT NULL) AND
108: (p_inserting OR (p_updating AND
109: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
110: <> new_references.expiry_dt)))
111: THEN
112: IF IGS_EN_VAL_PCE.enrp_val_strt_exp_dt (
113: new_references.pue_start_dt,