APPS.PON_OEX_TIMEZONE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

    SELECT COUNT(upgrade_tz_id) INTO valid
    FROM fnd_timezones_b
    WHERE upgrade_tz_id = tz_id
    and enabled_flag= 'Y';

Line: 126

	    select user_name
	    into l_user_name
	    from fnd_user
        where person_party_id = p_person_party_id
        and nvl(end_date,sysdate) >= sysdate;

Line: 142

	      select user_name
	      into l_user_name
	      from fnd_user
          where person_party_id = p_person_party_id
          and nvl(end_date,sysdate) >= sysdate
          and rownum=1;