APPS.CS_GET_REACTION_TIMES_PUB dependencies on CS_TIME_ZONES

Line 29: FROM CS_TIME_ZONES TZ1

25: CURSOR GMT_csr IS
26: SELECT TO_CHAR(TZ1.Offset_Time,'HH24') Offset_Hours,
27: TO_CHAR(TZ1.Offset_Time,'MI') Offset_Mts,
28: TZ1.Offset_Indicator Offset_Indicator
29: FROM CS_TIME_ZONES TZ1
30: WHERE TZ1.Time_Zone_Id = p_time_zone_id;
31:
32: l_offset_hours NUMBER;
33: l_offset_mts NUMBER;

Line 90: FROM CS_TIME_ZONES TZ1

86: CURSOR GMT_csr IS
87: SELECT TO_CHAR(TZ1.Offset_Time,'HH24') Offset_Hours,
88: TO_CHAR(TZ1.Offset_Time,'MI') Offset_Mts,
89: TZ1.Offset_Indicator Offset_Indicator
90: FROM CS_TIME_ZONES TZ1
91: WHERE TZ1.Time_Zone_Id = p_time_zone_id;
92:
93: l_offset_hours NUMBER;
94: l_offset_mts NUMBER;