APPS.HR_POSITION_API dependencies on PER_SHARED_TYPES

Line 25: from per_shared_types

21: l_valid_grades_changed1 boolean;
22: l_availability_status_id number;
23: Cursor c2 is
24: Select SHARED_TYPE_ID
25: from per_shared_types
26: where LOOKUP_TYPE = 'POSITION_AVAILABILITY_STATUS'
27: AND SYSTEM_TYPE_CD = 'ELIMINATED';
28: --
29: cursor c3 is

Line 646: from per_shared_types

642: p_availability_status_id number) return varchar2 is
643: --
644: cursor csr_lookup is
645: select system_type_cd
646: from per_shared_types
647: where shared_type_id = p_availability_status_id;
648: --
649: v_meaning varchar2(30) := null;
650: --

Line 2059: from per_shared_types

2055: where pd.position_definition_id = l_position_definition_id;
2056: --
2057: cursor c1 is
2058: select SHARED_TYPE_ID
2059: from per_shared_types
2060: where LOOKUP_TYPE = 'POSITION_AVAILABILITY_STATUS'
2061: AND SYSTEM_TYPE_CD = 'ACTIVE'
2062: and (business_group_id = p_business_group_id or business_group_id is null);
2063: --