DBA Data[Home] [Help]

APPS.IGS_ST_GVT_SPSHT_CTL_PKG dependencies on IGS_GE_DATE

Line 70: IF NVL(old_references.ess_snapshot_dt_time, IGS_GE_DATE.igsdate('1900/01/01')) <>

66: p_deleting IN BOOLEAN DEFAULT FALSE
67: ) AS
68: v_message_name VARCHAR2(30);
69: BEGIN
70: IF NVL(old_references.ess_snapshot_dt_time, IGS_GE_DATE.igsdate('1900/01/01')) <>
71: NVL(new_references.ess_snapshot_dt_time,IGS_GE_DATE.igsdate('1900/01/01')) THEN
72:
73: IF IGS_ST_VAL_GSC.stap_val_gsc_sdt (
74: new_references.submission_yr,

Line 71: NVL(new_references.ess_snapshot_dt_time,IGS_GE_DATE.igsdate('1900/01/01')) THEN

67: ) AS
68: v_message_name VARCHAR2(30);
69: BEGIN
70: IF NVL(old_references.ess_snapshot_dt_time, IGS_GE_DATE.igsdate('1900/01/01')) <>
71: NVL(new_references.ess_snapshot_dt_time,IGS_GE_DATE.igsdate('1900/01/01')) THEN
72:
73: IF IGS_ST_VAL_GSC.stap_val_gsc_sdt (
74: new_references.submission_yr,
75: new_references.ess_snapshot_dt_time,