APPS.PAY_CA_ARCHIVE dependencies on FND_DATE

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

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

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

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

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

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

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

1687: into l_value;
1688: close cur_edor;
1689:
1690: hr_utility.trace('func_expected_date_of_return l_value = ' || l_value);
1691: l_temp_date := fnd_date.canonical_to_date(l_value);
1692:
1693: return l_temp_date;
1694:
1695: end;

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

2206:
2207: end if;
2208:
2209: l_prev_roe_date :=
2210: fnd_date.canonical_to_date(archive_value(p_assactid,'PREV_ROE_DATE'));
2211: l_roe_date :=
2212: fnd_date.canonical_to_date(archive_value(p_assactid,'ROE_DATE'));
2213: l_assignment_id := archive_value(p_assactid,'ROE_ASSIGNMENT_ID');
2214: l_tax_unit_id := archive_value(p_assactid,'ROE_GRE_ID');

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

2208:
2209: l_prev_roe_date :=
2210: fnd_date.canonical_to_date(archive_value(p_assactid,'PREV_ROE_DATE'));
2211: l_roe_date :=
2212: fnd_date.canonical_to_date(archive_value(p_assactid,'ROE_DATE'));
2213: l_assignment_id := archive_value(p_assactid,'ROE_ASSIGNMENT_ID');
2214: l_tax_unit_id := archive_value(p_assactid,'ROE_GRE_ID');
2215: l_payroll_id := archive_value(p_assactid,'ROE_PAYROLL_ID');
2216: