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 757: FROM per_person_types

753:
754: CURSOR csr_pt
755: IS
756: SELECT system_person_type
757: FROM per_person_types
758: WHERE business_group_id = p_business_group_id
759: AND person_type_id = p_person_type_id;
760:
761: CURSOR csr_ptu

Line 765: ,per_person_types ppt

761: CURSOR csr_ptu
762: IS
763: SELECT ppt.system_person_type
764: FROM per_person_type_usages_f pptu
765: ,per_person_types ppt
766: WHERE pptu.person_type_id = ppt.person_type_id
767: AND pptu.person_id = p_person_id
768: AND ppt.business_group_id = p_business_group_id
769: AND p_effective_date BETWEEN pptu.effective_start_date

Line 772: l_person_type per_person_types.system_person_type%TYPE;

768: AND ppt.business_group_id = p_business_group_id
769: AND p_effective_date BETWEEN pptu.effective_start_date
770: AND pptu.effective_end_date;
771:
772: l_person_type per_person_types.system_person_type%TYPE;
773: l_value hr_lookups.meaning%TYPE;
774: l_pan_af hr_lookups.lookup_code%TYPE;
775: l_military_status hr_lookups.lookup_code%TYPE;
776: l_resident_status hr_lookups.lookup_code%TYPE;