APPS.IGS_OR_VAL_OU dependencies on IGS_GE_DATE

Line 859: v_end_dt := IGS_GE_DATE.IGSDATE('9999/01/01');

855:
856: IF (p_end_dt IS NULL) THEN
857:
858:
859: v_end_dt := IGS_GE_DATE.IGSDATE('9999/01/01');
860:
861:
862: ELSE
863:

Line 880: (p_start_dt <= NVL(ou.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN

876:
877: IF (p_start_dt >= ou.start_dt) AND
878:
879:
880: (p_start_dt <= NVL(ou.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN
881:
882:
883: p_message_name := 'IGS_OR_ORG_UNIT_OVERLAPS';
884:

Line 898: (v_end_dt <= NVL(ou.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN

894:
895: IF (v_end_dt >= ou.start_dt) AND
896:
897:
898: (v_end_dt <= NVL(ou.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN
899:
900:
901: p_message_name := 'IGS_OR_ORG_UNIT_OVERLAPS';
902:

Line 916: v_end_dt >= NVL(ou.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN

912:
913: IF (p_start_dt <= ou.start_dt AND
914:
915:
916: v_end_dt >= NVL(ou.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN
917:
918:
919: p_message_name := 'IGS_OR_ORG_UNIT_OVERLAPS';
920: