APPS.HRUSERDT dependencies on FND_DATE

Line 112: 'D', to_char(fnd_date.canonical_to_date(p_row_value)),

108: and nvl (R.legislation_code,
109: g_leg_code) = g_leg_code
110: and decode
111: (TAB.user_key_units,
112: 'D', to_char(fnd_date.canonical_to_date(p_row_value)),
113: 'N', to_char(fnd_number.canonical_to_number(p_row_value)),
114: 'T', upper (p_row_value),
115: null) =
116: decode

Line 118: 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name)),

114: 'T', upper (p_row_value),
115: null) =
116: decode
117: (TAB.user_key_units,
118: 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name)),
119: 'N', to_char(fnd_number.canonical_to_number(R.row_low_range_or_name)),
120: 'T', upper (R.row_low_range_or_name),
121: null)
122: and CINST.user_row_id = R.user_row_id

Line 159: 'D', to_char(fnd_date.canonical_to_date(p_row_value)),

155: and nvl (R.legislation_code,
156: g_leg_code) = g_leg_code
157: and decode
158: (TAB.user_key_units,
159: 'D', to_char(fnd_date.canonical_to_date(p_row_value)),
160: 'N', p_row_value,
161: 'T', upper (p_row_value),
162: null) =
163: decode

Line 165: 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name)),

161: 'T', upper (p_row_value),
162: null) =
163: decode
164: (TAB.user_key_units,
165: 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name)),
166: 'N', R.row_low_range_or_name,
167: 'T', upper (R.row_low_range_or_name),
168: null)
169: and CINST.user_row_id = R.user_row_id