eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on FND_DATE

Line 674: and p_date_earned between fnd_date.canonical_to_date(pei.pei_information2)

670: and pap.person_id = pei.person_id
671: and pei.information_type = 'PER_KR_NP_EXCEPTIONS'
672: and p_date_earned between paa.effective_start_date and paa.effective_end_date
673: and p_date_earned between pap.effective_start_date and pap.effective_end_date
674: and p_date_earned between fnd_date.canonical_to_date(pei.pei_information2)
675: and fnd_date.canonical_to_date(pei.pei_information3);
676: --
677: begin
678: l_exception_flag :='N';

Line 675: and fnd_date.canonical_to_date(pei.pei_information3);

671: and pei.information_type = 'PER_KR_NP_EXCEPTIONS'
672: and p_date_earned between paa.effective_start_date and paa.effective_end_date
673: and p_date_earned between pap.effective_start_date and pap.effective_end_date
674: and p_date_earned between fnd_date.canonical_to_date(pei.pei_information2)
675: and fnd_date.canonical_to_date(pei.pei_information3);
676: --
677: begin
678: l_exception_flag :='N';
679: open csr_exception_flag;

Line 1344: and ptp.end_date >= fnd_date.canonical_to_date(pei_information9);

1340: and ptp.payroll_id = paa.payroll_id
1341: and p_date_earned between paa.effective_start_date and paa.effective_end_date
1342: and p_date_earned between pp.effective_start_date and pp.effective_end_date
1343: and p_date_earned between ptp.start_date and ptp.end_date
1344: and ptp.end_date >= fnd_date.canonical_to_date(pei_information9);
1345:
1346:
1347: cursor csr_ei_exception_code
1348: is

Line 1361: and fnd_date.canonical_to_date(pei.pei_information2) <= ptp.end_date

1357: and pei.information_type ='PER_KR_EI_EXCEPTIONS'
1358: and p_date_earned between paa.effective_start_date and paa.effective_end_date
1359: and ptp.payroll_id = paa.payroll_id
1360: and p_date_earned between ptp.start_date and ptp.end_date
1361: and fnd_date.canonical_to_date(pei.pei_information2) <= ptp.end_date
1362: and fnd_date.canonical_to_date(pei.pei_information3) >= ptp.start_date
1363: order by pei.pei_information2 desc,pei.pei_information3 desc;
1364:
1365: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;

Line 1362: and fnd_date.canonical_to_date(pei.pei_information3) >= ptp.start_date

1358: and p_date_earned between paa.effective_start_date and paa.effective_end_date
1359: and ptp.payroll_id = paa.payroll_id
1360: and p_date_earned between ptp.start_date and ptp.end_date
1361: and fnd_date.canonical_to_date(pei.pei_information2) <= ptp.end_date
1362: and fnd_date.canonical_to_date(pei.pei_information3) >= ptp.start_date
1363: order by pei.pei_information2 desc,pei.pei_information3 desc;
1364:
1365: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1366: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;

Line 2109: SELECT nvl(fnd_date.canonical_to_date(prrv.result_value), to_date('01-01-1900','dd-mm-yyyy'))

2105: IS
2106: --
2107: l_dummy pay_run_result_values.result_value%type;
2108: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2, l_element_name varchar2) is
2109: SELECT nvl(fnd_date.canonical_to_date(prrv.result_value), to_date('01-01-1900','dd-mm-yyyy'))
2110: FROM pay_input_values_f piv
2111: ,pay_run_result_values prrv
2112: ,pay_run_results prr
2113: ,pay_payroll_actions ppa

Line 2254: SELECT fnd_date.canonical_to_date(peevf.screen_entry_value) dt_value

2250:
2251: /* Cursor to fetch the Hiring, Leaving and Final Interim Separation Pay date for the previous
2252: employer to calculate the Service Period and Overlap Periods */
2253: cursor get_prev_hire_leave_dt(l_effective_date in date, l_assignment_id in number, l_element_entry_id in number) is
2254: SELECT fnd_date.canonical_to_date(peevf.screen_entry_value) dt_value
2255: FROM pay_element_entry_values_f peevf,
2256: pay_element_entries_f peef,
2257: pay_element_types_f petf,
2258: pay_input_values_f pivf

Line 4108: l_year := to_number(to_char(fnd_date.canonical_to_date(p_effective_date),'YYYY'));

4104: l_year number := null;
4105: --
4106: begin
4107: --
4108: l_year := to_number(to_char(fnd_date.canonical_to_date(p_effective_date),'YYYY'));
4109: if l_year < 2009 then
4110: l_meaning := hr_general.decode_lookup('CONTACT',p_code);
4111: else
4112: l_meaning := hr_general.decode_lookup('KR_CONTACT_RELATIONSHIPS',p_code);

Line 4275: select fnd_date.canonical_to_date(aei.AEI_INFORMATION1),

4271: ) return number
4272: is
4273: cursor get_dff_segment_values
4274: is
4275: select fnd_date.canonical_to_date(aei.AEI_INFORMATION1),
4276: fnd_date.canonical_to_date(aei.AEI_INFORMATION2)
4277: from per_assignment_extra_info aei
4278: where aei.information_type = p_information_type
4279: and aei.assignment_id = p_assignment_id;

Line 4276: fnd_date.canonical_to_date(aei.AEI_INFORMATION2)

4272: is
4273: cursor get_dff_segment_values
4274: is
4275: select fnd_date.canonical_to_date(aei.AEI_INFORMATION1),
4276: fnd_date.canonical_to_date(aei.AEI_INFORMATION2)
4277: from per_assignment_extra_info aei
4278: where aei.information_type = p_information_type
4279: and aei.assignment_id = p_assignment_id;
4280: