eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_026 dependencies on IGS_GE_DATE

Line 2487: AND (NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))

2483: cp_end_date VARCHAR2) IS
2484: SELECT count(1) FROM IGS_PE_EIT
2485: WHERE person_id = cp_eit_rec.person_id
2486: AND INFORMATION_TYPE = cp_eit_rec.information_type
2487: AND (NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))
2488: OR
2489: cp_eit_rec.start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))
2490: OR
2491: ( cp_eit_rec.start_date < START_DATE AND

Line 2489: cp_eit_rec.start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))

2485: WHERE person_id = cp_eit_rec.person_id
2486: AND INFORMATION_TYPE = cp_eit_rec.information_type
2487: AND (NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))
2488: OR
2489: cp_eit_rec.start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))
2490: OR
2491: ( cp_eit_rec.start_date < START_DATE AND
2492: NVL(end_date,IGS_GE_DATE.igsdate(cp_end_date))< NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) ) );
2493:

Line 2492: NVL(end_date,IGS_GE_DATE.igsdate(cp_end_date))< NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) ) );

2488: OR
2489: cp_eit_rec.start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))
2490: OR
2491: ( cp_eit_rec.start_date < START_DATE AND
2492: NVL(end_date,IGS_GE_DATE.igsdate(cp_end_date))< NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) ) );
2493:
2494: BEGIN
2495: --CALL TO EIT INSERT RECORD
2496:

Line 2595: AND (NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))

2591: SELECT count(1) FROM IGS_PE_EIT
2592: WHERE person_id = cp_eit_rec.person_id
2593: AND information_type = cp_eit_rec.information_type
2594: AND start_date <> cp_eit_rec.start_date
2595: AND (NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))
2596: OR
2597: cp_eit_rec.start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))
2598: OR
2599: ( cp_eit_rec.start_date < START_DATE AND

Line 2597: cp_eit_rec.start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))

2593: AND information_type = cp_eit_rec.information_type
2594: AND start_date <> cp_eit_rec.start_date
2595: AND (NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))
2596: OR
2597: cp_eit_rec.start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))
2598: OR
2599: ( cp_eit_rec.start_date < START_DATE AND
2600: NVL(end_date,IGS_GE_DATE.igsdate(cp_end_date))< NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) ) );
2601:

Line 2600: NVL(end_date,IGS_GE_DATE.igsdate(cp_end_date))< NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) ) );

2596: OR
2597: cp_eit_rec.start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate(cp_end_date))
2598: OR
2599: ( cp_eit_rec.start_date < START_DATE AND
2600: NVL(end_date,IGS_GE_DATE.igsdate(cp_end_date))< NVL(cp_eit_rec.end_date,IGS_GE_DATE.igsdate(cp_end_date)) ) );
2601:
2602: BEGIN
2603: --CALL TO EIT INSERT RECORD
2604: