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

Line 735: FROM per_person_types

731:
732: CURSOR csr_pt
733: IS
734: SELECT system_person_type
735: FROM per_person_types
736: WHERE business_group_id = p_business_group_id
737: AND person_type_id = p_person_type_id;
738:
739: CURSOR csr_ptu

Line 743: ,per_person_types ppt

739: CURSOR csr_ptu
740: IS
741: SELECT ppt.system_person_type
742: FROM per_person_type_usages_f pptu
743: ,per_person_types ppt
744: WHERE pptu.person_type_id = ppt.person_type_id
745: AND pptu.person_id = p_person_id
746: AND ppt.business_group_id = p_business_group_id
747: AND p_effective_date BETWEEN pptu.effective_start_date

Line 750: l_person_type per_person_types.system_person_type%TYPE;

746: AND ppt.business_group_id = p_business_group_id
747: AND p_effective_date BETWEEN pptu.effective_start_date
748: AND pptu.effective_end_date;
749:
750: l_person_type per_person_types.system_person_type%TYPE;
751: l_value hr_lookups.meaning%TYPE;
752: l_pan_af hr_lookups.lookup_code%TYPE;
753: l_military_status hr_lookups.lookup_code%TYPE;
754: l_resident_status hr_lookups.lookup_code%TYPE;