APPS.HRUSERDT dependencies on FND_DATE

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

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

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

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

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

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

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

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