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 1760: from per_shared_types_vl

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

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

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

Line 2041: from hr_all_positions_f psf, per_shared_types sht

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