DBA Data[Home] [Help]

APPS.PAY_DK_BIK_UTILITY dependencies on FND_DATE

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

89: and nvl (R.legislation_code,
90: g_leg_code) = g_leg_code
91: and decode
92: (TAB.user_key_units,
93: 'D', to_char(fnd_date.canonical_to_date(p_row_value)),
94: 'N', to_char(fnd_number.canonical_to_number(p_row_value)),
95: 'T', upper (p_row_value),
96: null) =
97: decode

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

95: 'T', upper (p_row_value),
96: null) =
97: decode
98: (TAB.user_key_units,
99: 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name)),
100: 'N', to_char(fnd_number.canonical_to_number(R.row_low_range_or_name)),
101: 'T', upper (R.row_low_range_or_name),
102: null)
103: and CINST.user_row_id = R.user_row_id

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

132: and nvl (R.legislation_code,
133: g_leg_code) = g_leg_code
134: and decode
135: (TAB.user_key_units,
136: 'D', to_char(fnd_date.canonical_to_date(p_row_value)),
137: 'N', p_row_value,
138: 'T', upper (p_row_value),
139: null) =
140: decode

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

138: 'T', upper (p_row_value),
139: null) =
140: decode
141: (TAB.user_key_units,
142: 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name)),
143: 'N', R.row_low_range_or_name,
144: 'T', upper (R.row_low_range_or_name),
145: null)
146: and CINST.user_row_id = R.user_row_id