1211: ld_return_date DATE;
1212:
1213: BEGIN
1214: if length(p_char_date) = 19 then
1215: ld_return_date := fnd_date.canonical_to_date(p_char_date);
1216: else
1217: begin
1218: ld_return_date := fnd_date.chardate_to_date(p_char_date);
1219:
1214: if length(p_char_date) = 19 then
1215: ld_return_date := fnd_date.canonical_to_date(p_char_date);
1216: else
1217: begin
1218: ld_return_date := fnd_date.chardate_to_date(p_char_date);
1219:
1220: exception
1221: when others then
1222: ld_return_date := null;
1692: pay_action_information pai
1693: where pps.person_id = p_person_id
1694: and pai.action_context_id = p_action_context_id
1695: and pai.action_information_category = 'EMPLOYEE DETAILS'
1696: /* and fnd_date.canonical_to_date(pai.action_information11) = pps.date_start;*/
1697: and format_to_date(pai.action_information11) = pps.date_start;
1698:
1699: /* Bug 3722370 - Introduced decode statement in WHERE clause */
1700: cursor c_get_term_details(p_actual_termination_date varchar2,