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 572: and p_date_earned between fnd_date.canonical_to_date(pei.pei_information2)

568: and pap.person_id = pei.person_id
569: and pei.information_type = 'PER_KR_NP_EXCEPTIONS'
570: and p_date_earned between paa.effective_start_date and paa.effective_end_date
571: and p_date_earned between pap.effective_start_date and pap.effective_end_date
572: and p_date_earned between fnd_date.canonical_to_date(pei.pei_information2)
573: and fnd_date.canonical_to_date(pei.pei_information3);
574: --
575: begin
576: l_exception_flag :='N';

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

569: and pei.information_type = 'PER_KR_NP_EXCEPTIONS'
570: and p_date_earned between paa.effective_start_date and paa.effective_end_date
571: and p_date_earned between pap.effective_start_date and pap.effective_end_date
572: and p_date_earned between fnd_date.canonical_to_date(pei.pei_information2)
573: and fnd_date.canonical_to_date(pei.pei_information3);
574: --
575: begin
576: l_exception_flag :='N';
577: open csr_exception_flag;

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

1029: and ptp.payroll_id = paa.payroll_id
1030: and p_date_earned between paa.effective_start_date and paa.effective_end_date
1031: and p_date_earned between pp.effective_start_date and pp.effective_end_date
1032: and p_date_earned between ptp.start_date and ptp.end_date
1033: and ptp.end_date >= fnd_date.canonical_to_date(pei_information9);
1034:
1035:
1036: cursor csr_ei_exception_code
1037: is

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

1046: and pei.information_type ='PER_KR_EI_EXCEPTIONS'
1047: and p_date_earned between paa.effective_start_date and paa.effective_end_date
1048: and ptp.payroll_id = paa.payroll_id
1049: and p_date_earned between ptp.start_date and ptp.end_date
1050: and fnd_date.canonical_to_date(pei.pei_information2) <= ptp.end_date
1051: and fnd_date.canonical_to_date(pei.pei_information3) >= ptp.start_date
1052: order by pei.pei_information2 desc,pei.pei_information3 desc;
1053:
1054: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;

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

1047: and p_date_earned between paa.effective_start_date and paa.effective_end_date
1048: and ptp.payroll_id = paa.payroll_id
1049: and p_date_earned between ptp.start_date and ptp.end_date
1050: and fnd_date.canonical_to_date(pei.pei_information2) <= ptp.end_date
1051: and fnd_date.canonical_to_date(pei.pei_information3) >= ptp.start_date
1052: order by pei.pei_information2 desc,pei.pei_information3 desc;
1053:
1054: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1055: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;