APPS.IGS_PE_PERSENC_EFFCT_PKG dependencies on IGS_GE_DATE

Line 190: (NVL(old_references.pee_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

186: IF (new_references.pee_start_dt IS NOT NULL) THEN
187:
188: IF p_inserting OR (p_updating AND
189:
190: (NVL(old_references.pee_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
191:
192: <> new_references.pee_start_dt)) THEN
193:
194: IF IGS_EN_VAL_PCE.enrp_val_encmb_dt (

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

244: IF (new_references.expiry_dt IS NOT NULL) THEN
245:
246: IF p_inserting OR (p_updating AND
247:
248: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
249:
250: <> new_references.expiry_dt)) THEN
251:
252: IF IGS_EN_VAL_PCE.enrp_val_strt_exp_dt (

Line 494: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

490: END IF;
491:
492: IF p_updating AND
493:
494: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
495:
496: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
497:
498: -- Cannot call IGS_EN_GEN_011.ENRP_SET_PEN_EXPRY because trigger will be mutating.

Line 496: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

492: IF p_updating AND
493:
494: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
495:
496: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
497:
498: -- Cannot call IGS_EN_GEN_011.ENRP_SET_PEN_EXPRY because trigger will be mutating.
499:
500: -- Save the rowid of the current row.