APPS.PQP_GB_SWF_ARCHIVE dependencies on FND_DATE

Line 1234: fnd_date.canonical_to_date(pei_information2) qt_status_date,

1230: and csr_effective_date between pap.effective_start_date and pap.effective_end_date;
1231:
1232: cursor get_swf_dff_vaues(p_person_id in number) is
1233: select hr_general.decode_lookup('YES_NO',pei_information1 ) qt_sts,
1234: fnd_date.canonical_to_date(pei_information2) qt_status_date,
1235: pei_information3 qts_route,
1236: pei_information4 teacher_number,
1237: pei_information5 workforce_inc_typ,
1238: hr_general.decode_lookup('YES_NO',pei_information9) hlta_sts,

Line 1725: p_inputs(2).value := fnd_date.date_to_canonical(p_effective_date);

1721: -- setting the contexts
1722: p_inputs(1).name := 'ASSIGNMENT_ID';
1723: p_inputs(1).value := p_assignment_id;
1724: p_inputs(2).name := 'EFFECTIVE_DATE';
1725: p_inputs(2).value := fnd_date.date_to_canonical(p_effective_date);
1726: p_inputs(3).name := 'BUSINESS_GROUP_ID';
1727: p_inputs(3).value := p_business_group_id;
1728:
1729: l_formula_id := null;

Line 1811: p_inputs(2).value := fnd_date.date_to_canonical(p_effective_date);

1807: -- setting the contexts
1808: p_inputs(1).name := 'ASSIGNMENT_ID';
1809: p_inputs(1).value := p_assignment_id;
1810: p_inputs(2).name := 'DATE_EARNED';
1811: p_inputs(2).value := fnd_date.date_to_canonical(p_effective_date);
1812: p_inputs(3).name := 'BUSINESS_GROUP_ID';
1813: p_inputs(3).value := p_business_group_id;
1814:
1815: l_formula_id := null;