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.PQH_LENGTH_OF_SERVICE_PKG dependencies on FND_DATE

Line 603: AND p_effective_date between fnd_date.canonical_to_date(peit.pei_information2)

599: FROM per_people_extra_info peit
600: WHERE peit.person_id = p_person_id
601: AND peit.information_type = 'FR_PQH_ADDL_SENIORITY_INFO'
602: AND peit.pei_information1 = p_los_type
603: AND p_effective_date between fnd_date.canonical_to_date(peit.pei_information2)
604: AND NVL(fnd_date.canonical_to_date(peit.pei_information3),g_end_of_time);
605: BEGIN
606: hr_utility.set_location('Entering '||l_proc,1);
607: OPEN Csr_correction;

Line 604: AND NVL(fnd_date.canonical_to_date(peit.pei_information3),g_end_of_time);

600: WHERE peit.person_id = p_person_id
601: AND peit.information_type = 'FR_PQH_ADDL_SENIORITY_INFO'
602: AND peit.pei_information1 = p_los_type
603: AND p_effective_date between fnd_date.canonical_to_date(peit.pei_information2)
604: AND NVL(fnd_date.canonical_to_date(peit.pei_information3),g_end_of_time);
605: BEGIN
606: hr_utility.set_location('Entering '||l_proc,1);
607: OPEN Csr_correction;
608: FETCH Csr_correction INTO l_correct_days;

Line 651: AND (NVL(fnd_date.canonical_to_date(pei_information3),g_end_of_time) BETWEEN p_start_date AND p_end_date

647: SELECT NVL(pei_information7,0) LENGTH_OF_SERVICE
648: FROM per_people_extra_info
649: WHERE person_id = p_person_id
650: AND information_type = 'FR_PQH_BONIFICATION_DETAILS'
651: AND (NVL(fnd_date.canonical_to_date(pei_information3),g_end_of_time) BETWEEN p_start_date AND p_end_date
652: OR fnd_date.canonical_to_date(pei_information2) BETWEEN p_start_date AND p_end_date );
653:
654: BEGIN
655: hr_utility.set_location('Entering '||l_proc,1);

Line 652: OR fnd_date.canonical_to_date(pei_information2) BETWEEN p_start_date AND p_end_date );

648: FROM per_people_extra_info
649: WHERE person_id = p_person_id
650: AND information_type = 'FR_PQH_BONIFICATION_DETAILS'
651: AND (NVL(fnd_date.canonical_to_date(pei_information3),g_end_of_time) BETWEEN p_start_date AND p_end_date
652: OR fnd_date.canonical_to_date(pei_information2) BETWEEN p_start_date AND p_end_date );
653:
654: BEGIN
655: hr_utility.set_location('Entering '||l_proc,1);
656: l_emp_type := get_employee_type(p_person_id => p_person_id,

Line 1499: AND p_start_date = fnd_date.canonical_to_date(pei_information1)

1495: SELECT nvl((p_end_date - p_start_date),0) los
1496: FROM per_people_extra_info
1497: WHERE person_id = p_person_id
1498: AND information_type = 'DE_MILITARY_SERVICE'
1499: AND p_start_date = fnd_date.canonical_to_date(pei_information1)
1500: AND p_end_date = fnd_date.canonical_to_date(pei_information2);
1501:
1502: BEGIN
1503: hr_utility.set_location('Entering '||l_proc,1);

Line 1500: AND p_end_date = fnd_date.canonical_to_date(pei_information2);

1496: FROM per_people_extra_info
1497: WHERE person_id = p_person_id
1498: AND information_type = 'DE_MILITARY_SERVICE'
1499: AND p_start_date = fnd_date.canonical_to_date(pei_information1)
1500: AND p_end_date = fnd_date.canonical_to_date(pei_information2);
1501:
1502: BEGIN
1503: hr_utility.set_location('Entering '||l_proc,1);
1504: l_emp_type := get_employee_type(p_person_id => p_person_id,

Line 2661: AND p_effective_date BETWEEN fnd_date.canonical_to_date(pei.pei_information2)

2657: FROM per_people_extra_info pei
2658: WHERE pei.person_id = p_person_id
2659: AND pei.information_type ='DE_PQH_POE_INFO'
2660: AND pei.pei_information1 = p_los_type
2661: AND p_effective_date BETWEEN fnd_date.canonical_to_date(pei.pei_information2)
2662: AND NVL(fnd_date.canonical_to_date(pei.pei_information3),g_end_of_time);
2663:
2664: l_correction_factor per_people_extra_info.pei_information4%TYPE;
2665:

Line 2662: AND NVL(fnd_date.canonical_to_date(pei.pei_information3),g_end_of_time);

2658: WHERE pei.person_id = p_person_id
2659: AND pei.information_type ='DE_PQH_POE_INFO'
2660: AND pei.pei_information1 = p_los_type
2661: AND p_effective_date BETWEEN fnd_date.canonical_to_date(pei.pei_information2)
2662: AND NVL(fnd_date.canonical_to_date(pei.pei_information3),g_end_of_time);
2663:
2664: l_correction_factor per_people_extra_info.pei_information4%TYPE;
2665:
2666: BEGIN