APPS.HR_POSITION_API dependencies on PER_POSITION_DEFINITIONS

Line 115: -- Function to delete unused per_position_definitions

111: hr_utility.set_location('Leaving:'|| l_proc, 30);
112: end if;
113: end;
114: --
115: -- Function to delete unused per_position_definitions
116: --
117: function delete_unused_per_pos_def(p_position_definition_id number)
118: return boolean is
119: --

Line 151: delete from per_position_definitions

147: return false;
148: end if;
149: close c_per_pos_def_used;
150: --
151: delete from per_position_definitions
152: where position_definition_id = p_position_definition_id;
153: --
154: return true;
155: --

Line 302: -- bug 2271064 get per_position_definitions segment values where

298: select business_group_id
299: from per_jobs
300: where job_id = p_job_id;
301: --
302: -- bug 2271064 get per_position_definitions segment values where
303: -- position_definition_id is known
304: --
305: cursor c_segments is
306: select segment1,

Line 336: from per_position_definitions

332: segment27,
333: segment28,
334: segment29,
335: segment30
336: from per_position_definitions
337: where position_definition_id = l_position_definition_id;
338: --
339: begin
340: --

Line 852: from per_position_definitions pd

848: -- Declare cursors
849: --
850: cursor csr_idsel is
851: select pd.id_flex_num
852: from per_position_definitions pd
853: where pd.position_definition_id = l_position_definition_id;
854: --
855: cursor get_curr_esd ( p_position_id in number) is
856: select

Line 862: -- bug 2271064 get per_position_definitions segment values where

858: from hr_all_positions_f
859: where position_id = p_position_id and
860: nvl(copied_to_old_table_flag, 'N') = 'Y';
861: --
862: -- bug 2271064 get per_position_definitions segment values where
863: -- position_definition_id is known
864: --
865: cursor c_segments is
866: select segment1,

Line 896: from per_position_definitions

892: segment27,
893: segment28,
894: segment29,
895: segment30
896: from per_position_definitions
897: where position_definition_id = l_position_definition_id;
898: --
899: begin
900: --

Line 2054: from per_position_definitions pd

2050: where pbg.business_group_id = l_business_group_id;
2051: --
2052: cursor csr_idsel is
2053: select pd.id_flex_num
2054: from per_position_definitions pd
2055: where pd.position_definition_id = l_position_definition_id;
2056: --
2057: cursor c1 is
2058: select SHARED_TYPE_ID

Line 2069: -- bug 2271064 get per_position_definitions segment values where

2065: select object_version_number
2066: from per_all_positions
2067: where position_id = p_position_id;
2068: --
2069: -- bug 2271064 get per_position_definitions segment values where
2070: -- position_definition_id is known
2071: --
2072: cursor c_segments is
2073: select segment1,

Line 2103: from per_position_definitions

2099: segment27,
2100: segment28,
2101: segment29,
2102: segment30
2103: from per_position_definitions
2104: where position_definition_id = l_position_definition_id;
2105: --
2106: begin
2107: --

Line 3216: from per_position_definitions pd

3212: -- Declare cursors
3213: --
3214: cursor csr_idsel is
3215: select pd.id_flex_num
3216: from per_position_definitions pd
3217: where pd.position_definition_id = l_position_definition_id;
3218: --
3219: cursor csr_isfirstrow is
3220: select min(effective_start_date)

Line 3224: -- bug 2271064 get per_position_definitions segment values where

3220: select min(effective_start_date)
3221: from hr_all_positions_f
3222: where position_id = p_position_id;
3223: --
3224: -- bug 2271064 get per_position_definitions segment values where
3225: -- position_definition_id is known
3226: --
3227: cursor c_segments is
3228: select segment1,

Line 3258: from per_position_definitions

3254: segment27,
3255: segment28,
3256: segment29,
3257: segment30
3258: from per_position_definitions
3259: where position_definition_id = l_position_definition_id;
3260: --
3261: begin
3262: --

Line 4532: from hr_all_positions_f psf, per_position_definitions pd

4528: procedure regenerate_position_name(p_position_id number) is
4529: cursor c_position(p_position_id number) is
4530: select psf.effective_start_date, psf.position_definition_id,
4531: psf.object_version_number, pd.id_flex_num
4532: from hr_all_positions_f psf, per_position_definitions pd
4533: where position_id = p_position_id
4534: and psf.position_definition_id = pd.position_definition_id
4535: and effective_end_date = hr_api.g_eot;
4536: --