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_GENERAL dependencies on PER_SHARED_TYPES

Line 160: hsajja 17-JAN-2002 115.36 NLS fix: Changed per_shared_types to

156: compilation changes.
157: stlocke 23-JAN-2001 115.33 Added procedure init-fndload.
158: stlocke 08-FEB-2001 115.34 Procedure init-fndload removed.
159: cnholmes 28-NOV-2001 115.35 Add iRecruitment to HRSM_OBJECT.
160: hsajja 17-JAN-2002 115.36 NLS fix: Changed per_shared_types to
161: per_shared_types_vl in function
162: DECODE_AVAILABILITY_STATUS
163: gsayers 05-FEB-2002 115.37 Added check to prevent '01/01/0001'-1
164: in init_forms.

Line 161: per_shared_types_vl in function

157: stlocke 23-JAN-2001 115.33 Added procedure init-fndload.
158: stlocke 08-FEB-2001 115.34 Procedure init-fndload removed.
159: cnholmes 28-NOV-2001 115.35 Add iRecruitment to HRSM_OBJECT.
160: hsajja 17-JAN-2002 115.36 NLS fix: Changed per_shared_types to
161: per_shared_types_vl in function
162: DECODE_AVAILABILITY_STATUS
163: gsayers 05-FEB-2002 115.37 Added check to prevent '01/01/0001'-1
164: in init_forms.
165: gperry 08-FEB-2002 115.38 Fixed WWBUG 2110218.

Line 1758: from per_shared_types_vl

1754: p_availability_status_id number) return varchar2 is
1755: --
1756: cursor csr_lookup is
1757: select shared_type_name
1758: from per_shared_types_vl
1759: where shared_type_id = p_availability_status_id;
1760: --
1761: v_meaning per_shared_types_vl.shared_type_name%TYPE := null;
1762: --

Line 1761: v_meaning per_shared_types_vl.shared_type_name%TYPE := null;

1757: select shared_type_name
1758: from per_shared_types_vl
1759: where shared_type_id = p_availability_status_id;
1760: --
1761: v_meaning per_shared_types_vl.shared_type_name%TYPE := null;
1762: --
1763: begin
1764: --
1765: -- Only open the cursor if the parameter is going to retrieve anything

Line 2039: from hr_all_positions_f psf, per_shared_types sht

2035: l_effective_start_date date;
2036: --
2037: cursor csr_date_end is
2038: select psf.effective_start_date - 1
2039: from hr_all_positions_f psf, per_shared_types sht
2040: where psf.position_id = p_position_id
2041: and psf.availability_status_id = sht.shared_type_id
2042: and sht.system_type_cd in ('DELETED','ELIMINATED');
2043: --