APPS.CS_ERES_INT_PKG dependencies on FND_TIMEZONES_B

Line 436: From fnd_timezones_b

432: l_date_format VARCHAR2(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
433:
434: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349
435: Select timezone_code
436: From fnd_timezones_b
437: Where upgrade_tz_id = l_time_zone_id;
438: l_source_tz_code varchar2(50);
439: l_dest_tz_code varchar2(50);
440:

Line 756: From fnd_timezones_b

752:
753: l_note_list cs_sr_note_list_t;
754: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349
755: Select timezone_code
756: From fnd_timezones_b
757: Where upgrade_tz_id = l_time_zone_id;
758: BEGIN
759: -- Begin Bug 11830349
760: Open timezone_code(l_source_timezone_id);

Line 854: From fnd_timezones_b

850:
851: l_task_list cs_sr_task_list_t;
852: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349
853: Select timezone_code
854: From fnd_timezones_b
855: Where upgrade_tz_id = l_time_zone_id;
856: BEGIN
857: -- Begin Bug 11830349
858: Open timezone_code(l_source_timezone_id);

Line 1244: FROM fnd_timezones_b tz, fnd_timezones_tl tz_tl

1240: --:TimeZone_Name
1241: --:display_timezone
1242: CURSOR Get_Timezone (v_time_zone_id NUMBER) IS
1243: SELECT tz_tl.name
1244: FROM fnd_timezones_b tz, fnd_timezones_tl tz_tl
1245: WHERE tz.upgrade_tz_id = v_time_zone_id
1246: AND tz.TIMEZONE_CODE = tz_tl.TIMEZONE_CODE
1247: AND tz_tl.language = USERENV('LANG');
1248:

Line 1465: From fnd_timezones_b

1461: l_escalation VARCHAR2(80);
1462:
1463: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349
1464: Select timezone_code
1465: From fnd_timezones_b
1466: Where upgrade_tz_id = l_time_zone_id;
1467:
1468: BEGIN
1469: -- Log the input parameter