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_DA_PURGE_RQST_PKG dependencies on FND_DATE

Line 170: AND ((p_c_start_date IS NULL)OR ( p_c_start_date IS NOT NULL AND dar.creation_date >= fnd_date.canonical_to_date (p_c_start_date)))

166: AND dar.requestor_id = NVL(p_requestor_id, dar.requestor_id)
167: AND dac.responsibility_name = NVL(p_responsibility,dac.responsibility_name)
168: AND dar.request_status = NVL(p_request_status,dar.request_status)
169: AND dacr.request_type =NVL(p_request_type,dacr.request_type)
170: AND ((p_c_start_date IS NULL)OR ( p_c_start_date IS NOT NULL AND dar.creation_date >= fnd_date.canonical_to_date (p_c_start_date)))
171: AND ((p_c_end_date IS NULL)OR ( p_c_end_date IS NOT NULL AND dar.creation_date <= fnd_date.canonical_to_date (p_c_end_date)))
172: AND dar.requestor_id = pbv1.person_id
173: AND dac.request_type_id(+) = dar.request_type_id ;
174:

Line 171: AND ((p_c_end_date IS NULL)OR ( p_c_end_date IS NOT NULL AND dar.creation_date <= fnd_date.canonical_to_date (p_c_end_date)))

167: AND dac.responsibility_name = NVL(p_responsibility,dac.responsibility_name)
168: AND dar.request_status = NVL(p_request_status,dar.request_status)
169: AND dacr.request_type =NVL(p_request_type,dacr.request_type)
170: AND ((p_c_start_date IS NULL)OR ( p_c_start_date IS NOT NULL AND dar.creation_date >= fnd_date.canonical_to_date (p_c_start_date)))
171: AND ((p_c_end_date IS NULL)OR ( p_c_end_date IS NOT NULL AND dar.creation_date <= fnd_date.canonical_to_date (p_c_end_date)))
172: AND dar.requestor_id = pbv1.person_id
173: AND dac.request_type_id(+) = dar.request_type_id ;
174:
175: --