APPS.HR_PSF_SHD dependencies on PER_SHARED_TYPES

Line 14: from per_shared_types

10: function get_availability_status(p_availability_status_id number
11: ,p_business_group_id number)
12: return varchar2 is
13: cursor c1 is select system_type_cd
14: from per_shared_types
15: where shared_type_id = p_availability_status_id
16: and lookup_type ='POSITION_AVAILABILITY_STATUS'
17: and (business_group_id = p_business_group_id or business_group_id is null);
18: l_avail_status varchar2(30);

Line 59: from per_shared_types sht, hr_all_positions_f psf

55: p_effective_date date) return varchar2 is
56: --
57: cursor csr_lookup is
58: select system_type_cd
59: from per_shared_types sht, hr_all_positions_f psf
60: where shared_type_id = psf.availability_status_id
61: and psf.position_id = p_position_id
62: and p_effective_date between psf.effective_start_date and psf.effective_end_date;
63: --

Line 88: from per_shared_types

84: p_availability_status_id number) return varchar2 is
85: --
86: cursor csr_lookup is
87: select system_type_cd
88: from per_shared_types
89: where shared_type_id = p_availability_status_id;
90: --
91: v_meaning varchar2(30) := null;
92: --