APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 599: FROM per_people_extra_info peit

595: l_proc varchar2(60) := g_package||'get_correction_factor';
596:
597: CURSOR Csr_correction IS
598: SELECT NVL(fnd_number.canonical_to_number(peit.pei_information4),0)
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)

Line 648: FROM per_people_extra_info

644: AND g_determination_date BETWEEN effective_start_date AND NVL(effective_end_date,g_end_of_time);
645:
646: CURSOR csr_military_periods IS
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 );

Line 1496: FROM per_people_extra_info

1492: AND p_end_date BETWEEN effective_start_date AND NVL(effective_end_date,g_end_of_time);
1493:
1494: CURSOR csr_military_periods IS
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);

Line 2657: FROM per_people_extra_info pei

2653: RETURN VARCHAR2 IS
2654:
2655: CURSOR c_correction_factor IS
2656: SELECT nvl(pei.pei_information4,'0')
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)

Line 2664: l_correction_factor per_people_extra_info.pei_information4%TYPE;

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
2667:
2668: OPEN c_correction_factor;