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.HR_RU_PEOPLE_LEG_HOOK dependencies on PER_PERSON_TYPES

Line 791: l_system_person_type per_person_types.system_person_type%TYPE;

787: l_age NUMBER;
788: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
789: l_sex per_all_people_f.sex%TYPE;
790: l_per_information5 per_all_people_f.per_information5%TYPE;
791: l_system_person_type per_person_types.system_person_type%TYPE;
792: l_seeded_person_type_key per_person_types.seeded_person_type_key%TYPE;
793: l_effective_date DATE;
794:
795: CURSOR csr_get_person_info (p_id NUMBER)

Line 792: l_seeded_person_type_key per_person_types.seeded_person_type_key%TYPE;

788: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
789: l_sex per_all_people_f.sex%TYPE;
790: l_per_information5 per_all_people_f.per_information5%TYPE;
791: l_system_person_type per_person_types.system_person_type%TYPE;
792: l_seeded_person_type_key per_person_types.seeded_person_type_key%TYPE;
793: l_effective_date DATE;
794:
795: CURSOR csr_get_person_info (p_id NUMBER)
796: IS

Line 808: FROM per_person_types ppt, per_person_type_usages_f ptu

804:
805: CURSOR csr_ptu_type (c_person_id NUMBER, c_session_date DATE)
806: IS
807: SELECT ppt.system_person_type, ppt.seeded_person_type_key
808: FROM per_person_types ppt, per_person_type_usages_f ptu
809: WHERE ppt.person_type_id = ptu.person_type_id
810: AND c_session_date BETWEEN ptu.effective_start_date
811: AND ptu.effective_end_date
812: AND ptu.person_id = c_person_id;