DBA Data[Home] [Help]

APPS.JTF_RESOURCE_UTL dependencies on HZ_TIMEZONES

Line 654: l_time_zone_id hz_timezones.timezone_id%TYPE;

650: (p_time_zone_id IN NUMBER,
651: x_return_status OUT NOCOPY VARCHAR2
652: ) IS
653:
654: l_time_zone_id hz_timezones.timezone_id%TYPE;
655:
656: CURSOR c_time_zone_id IS
657: /* Bug 7290999 (changed reference from hz_timezones_vl to fnd_timezones_vl)
658: SELECT timezone_id

Line 657: /* Bug 7290999 (changed reference from hz_timezones_vl to fnd_timezones_vl)

653:
654: l_time_zone_id hz_timezones.timezone_id%TYPE;
655:
656: CURSOR c_time_zone_id IS
657: /* Bug 7290999 (changed reference from hz_timezones_vl to fnd_timezones_vl)
658: SELECT timezone_id
659: FROM hz_timezones
660: WHERE timezone_id = p_time_zone_id;
661: */

Line 659: FROM hz_timezones

655:
656: CURSOR c_time_zone_id IS
657: /* Bug 7290999 (changed reference from hz_timezones_vl to fnd_timezones_vl)
658: SELECT timezone_id
659: FROM hz_timezones
660: WHERE timezone_id = p_time_zone_id;
661: */
662: SELECT upgrade_tz_id
663: FROM fnd_timezones_vl