DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on PER_SHARED_TYPES_VL

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