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 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