DBA Data[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_GE_DATE

Line 66: IF NVL(p_new_end_dt, igs_ge_date.igsdate('1000/01/01')) <>

62: BEGIN
63: -- Create a history for a IGS_FI_FEE_AS_RT record.
64: -- Check if any of the non-primary key fields have been changed
65: -- and set the flag v_create_history to indicate so.
66: IF NVL(p_new_end_dt, igs_ge_date.igsdate('1000/01/01')) <>
67: NVL(p_old_end_dt, igs_ge_date.igsdate('1000/01/01')) THEN
68: r_cfarh.end_dt := NVL(p_old_end_dt , NULL);
69: v_create_history := TRUE;
70: END IF;

Line 67: NVL(p_old_end_dt, igs_ge_date.igsdate('1000/01/01')) THEN

63: -- Create a history for a IGS_FI_FEE_AS_RT record.
64: -- Check if any of the non-primary key fields have been changed
65: -- and set the flag v_create_history to indicate so.
66: IF NVL(p_new_end_dt, igs_ge_date.igsdate('1000/01/01')) <>
67: NVL(p_old_end_dt, igs_ge_date.igsdate('1000/01/01')) THEN
68: r_cfarh.end_dt := NVL(p_old_end_dt , NULL);
69: v_create_history := TRUE;
70: END IF;
71: IF p_new_chg_rate <> p_old_chg_rate THEN