APPS.PAY_CA_ARCHIVE dependencies on FND_DATE

Line 695: select fnd_date.canonical_to_date(fai.value)

691: and ppa.report_type = 'ROE'
692: order by ppa.effective_date desc;
693:
694: cursor cur_dates (b_assignment_action_id number) is
695: select fnd_date.canonical_to_date(fai.value)
696: from ff_archive_items fai,
697: ff_database_items fdi
698: where fai.user_entity_id = fdi.user_entity_id
699: and fdi.user_name = 'ROE_DATE'

Line 1093: fnd_date.canonical_to_date(fai1.value) =

1089: paa.tax_unit_id = p_gre_id and
1090: paa.assignment_id = p_assignment_id and
1091: paa.assignment_action_id = fai1.context1 and
1092: fai1.user_entity_id = v_roe_date and
1093: fnd_date.canonical_to_date(fai1.value) =
1094: fnd_date.canonical_to_date(to_char(p_roe_date,'yyyy/mm/dd hh24:mi:ss')) and
1095: fai1.context1 = fai2.context1 and
1096: fai2.user_entity_id = v_payroll_id and
1097: fai2.value = to_char(p_payroll_id);

Line 1094: fnd_date.canonical_to_date(to_char(p_roe_date,'yyyy/mm/dd hh24:mi:ss')) and

1090: paa.assignment_id = p_assignment_id and
1091: paa.assignment_action_id = fai1.context1 and
1092: fai1.user_entity_id = v_roe_date and
1093: fnd_date.canonical_to_date(fai1.value) =
1094: fnd_date.canonical_to_date(to_char(p_roe_date,'yyyy/mm/dd hh24:mi:ss')) and
1095: fai1.context1 = fai2.context1 and
1096: fai2.user_entity_id = v_payroll_id and
1097: fai2.value = to_char(p_payroll_id);
1098:

Line 1687: l_temp_date := fnd_date.canonical_to_date(l_value);

1683: into l_value;
1684: close cur_edor;
1685:
1686: hr_utility.trace('func_expected_date_of_return l_value = ' || l_value);
1687: l_temp_date := fnd_date.canonical_to_date(l_value);
1688:
1689: return l_temp_date;
1690:
1691: end;

Line 2206: fnd_date.canonical_to_date(archive_value(p_assactid,'PREV_ROE_DATE'));

2202:
2203: end if;
2204:
2205: l_prev_roe_date :=
2206: fnd_date.canonical_to_date(archive_value(p_assactid,'PREV_ROE_DATE'));
2207: l_roe_date :=
2208: fnd_date.canonical_to_date(archive_value(p_assactid,'ROE_DATE'));
2209: l_assignment_id := archive_value(p_assactid,'ROE_ASSIGNMENT_ID');
2210: l_tax_unit_id := archive_value(p_assactid,'ROE_GRE_ID');

Line 2208: fnd_date.canonical_to_date(archive_value(p_assactid,'ROE_DATE'));

2204:
2205: l_prev_roe_date :=
2206: fnd_date.canonical_to_date(archive_value(p_assactid,'PREV_ROE_DATE'));
2207: l_roe_date :=
2208: fnd_date.canonical_to_date(archive_value(p_assactid,'ROE_DATE'));
2209: l_assignment_id := archive_value(p_assactid,'ROE_ASSIGNMENT_ID');
2210: l_tax_unit_id := archive_value(p_assactid,'ROE_GRE_ID');
2211: l_payroll_id := archive_value(p_assactid,'ROE_PAYROLL_ID');
2212: