APPS.HR_WPM_UTIL dependencies on PER_PEOPLE_EXTRA_INFO

Line 338: FROM per_people_extra_info

334: FROM (SELECT pei_information1 potential,
335: fnd_date.canonical_to_date (pei_information5) start_date,
336: fnd_date.canonical_to_date (pei_information6) end_date,
337: fnd_date.canonical_to_date (pei_information8) completion_date
338: FROM per_people_extra_info
339: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
340: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)
341: ORDER BY NVL (completion_date, start_date) DESC;
342:

Line 347: FROM per_people_extra_info

343: --
344: CURSOR csr_pot_old_eit (p_person_id NUMBER, p_effective_date DATE)
345: IS
346: SELECT pei_information1 potential
347: FROM per_people_extra_info
348: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_PLANNING';
349:
350: --
351: CURSOR csr_9box_new_potential (p_potential VARCHAR2)

Line 516: FROM per_people_extra_info

512: FROM (SELECT pei_information4 RETENTION,
513: fnd_date.canonical_to_date (pei_information5) start_date,
514: fnd_date.canonical_to_date (pei_information6) end_date,
515: fnd_date.canonical_to_date (pei_information8) completion_date
516: FROM per_people_extra_info
517: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
518: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)
519: ORDER BY NVL (completion_date, start_date) DESC;
520:

Line 525: FROM per_people_extra_info

521: --
522: CURSOR csr_ret_old_eit (p_person_id NUMBER, p_effective_date DATE)
523: IS
524: SELECT pei_information2 RETENTION
525: FROM per_people_extra_info
526: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_PLANNING';
527:
528: --
529: CURSOR csr_9box_new_retention (p_retention VARCHAR2)

Line 719: FROM per_people_extra_info

715: FROM (SELECT pei_information9 iol,
716: fnd_date.canonical_to_date (pei_information5) start_date,
717: fnd_date.canonical_to_date (pei_information6) end_date,
718: fnd_date.canonical_to_date (pei_information8) completion_date
719: FROM per_people_extra_info
720: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
721: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)
722: ORDER BY NVL (completion_date, start_date) DESC;
723:

Line 972: FROM per_people_extra_info

968: FROM (SELECT pei_information3 key_worker,
969: fnd_date.canonical_to_date (pei_information5) start_date,
970: fnd_date.canonical_to_date (pei_information6) end_date,
971: fnd_date.canonical_to_date (pei_information8) completion_date
972: FROM per_people_extra_info
973: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
974: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)
975: ORDER BY NVL (completion_date, start_date) DESC;
976: