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_HU_UPDATE_PERSON dependencies on PER_PERSON_TYPES

Line 18: FROM per_person_types ppt,per_person_type_usages_f ptu

14:
15: l_proc VARCHAR2(72) := g_package||'UPDATE_HU_PERSON';
16: CURSOR csr_person_type IS
17: SELECT ppt.system_person_type,ppt.seeded_person_type_key
18: FROM per_person_types ppt,per_person_type_usages_f ptu
19: WHERE ppt.person_type_id = ptu.person_type_id
20: AND p_effective_date BETWEEN ptu.effective_start_date AND ptu.effective_end_date
21: AND ptu.person_id = p_person_id;
22:

Line 23: l_person_type per_person_types.system_person_type%TYPE;

19: WHERE ppt.person_type_id = ptu.person_type_id
20: AND p_effective_date BETWEEN ptu.effective_start_date AND ptu.effective_end_date
21: AND ptu.person_id = p_person_id;
22:
23: l_person_type per_person_types.system_person_type%TYPE;
24: l_seed_person_type per_person_types.seeded_person_type_key%TYPE;
25: BEGIN
26: --
27: -- Added for GSI Bug 5472781

Line 24: l_seed_person_type per_person_types.seeded_person_type_key%TYPE;

20: AND p_effective_date BETWEEN ptu.effective_start_date AND ptu.effective_end_date
21: AND ptu.person_id = p_person_id;
22:
23: l_person_type per_person_types.system_person_type%TYPE;
24: l_seed_person_type per_person_types.seeded_person_type_key%TYPE;
25: BEGIN
26: --
27: -- Added for GSI Bug 5472781
28: --