DBA Data[Home] [Help]

APPS.JTF_RESOURCE_UTL dependencies on HZ_TIMEZONES

Line 656: l_time_zone_id hz_timezones.timezone_id%TYPE;

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

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

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

Line 661: FROM hz_timezones

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