APPS.PER_PSV_BUS dependencies on PER_POS_STRUCTURE_VERSIONS

Line 59: , per_pos_structure_versions psv

55: --
56: cursor csr_sec_grp is
57: select pbg.security_group_id
58: from per_business_groups pbg
59: , per_pos_structure_versions psv
60: where psv.pos_structure_version_id = p_pos_structure_version_id
61: and pbg.business_group_id = psv.business_group_id;
62: --
63: -- Declare local variables

Line 119: , per_pos_structure_versions psv

115: --
116: cursor csr_leg_code is
117: select pbg.legislation_code
118: from per_business_groups pbg
119: , per_pos_structure_versions psv
120: where psv.pos_structure_version_id = p_pos_structure_version_id
121: and pbg.business_group_id = psv.business_group_id;
122: --
123: -- Declare local variables

Line 218: from per_pos_structure_versions

214: );
215:
216: select count(*)
217: into l_count
218: from per_pos_structure_versions
219: where pos_structure_version_id in (p_src_psv_id,
220: p_dest_psv_id);
221: if l_count <> 2 then
222: null;

Line 289: from per_pos_structure_versions osv

285: --
286: p_gap_warning := FALSE;
287: select max(osv.date_to)
288: into l_max_end_date
289: from per_pos_structure_versions osv
290: where osv.date_from < p_Date_From
291: and osv.position_structure_id = p_position_structure_id
292: and osv.pos_structure_Version_id = nvl(p_pos_structure_version_id,-1);
293: --

Line 298: from per_pos_structure_versions osv

294: if (l_max_end_date is not null and p_Date_from = (l_max_end_date +1)
295: or (l_max_end_date is null)) then
296: select min(osv.date_from)
297: into l_min_start_date
298: from per_pos_structure_versions osv
299: where osv.position_structure_id = p_position_structure_id
300: and osv.date_from > p_Date_To
301: and osv.pos_structure_Version_id = nvl(p_pos_structure_version_id,-1);
302: --

Line 318: from per_pos_structure_versions osv

314: into l_dummy
315: from dual
316: where exists
317: (select 1
318: from per_pos_structure_versions osv
319: where osv.date_from <= nvl(p_Date_To, hr_api.g_eot)
320: and nvl(osv.date_to,hr_api.g_eot) >= p_Date_From
321: and osv.position_structure_id = p_position_structure_id
322: and osv.pos_structure_version_id

Line 359: from per_pos_structure_versions

355: -- Declare cursor
356: --
357: cursor csr_pos_version is
358: select pos_structure_version_id,business_group_id
359: from per_pos_structure_versions
360: where version_number = p_version_number
361: and nvl(p_pos_structure_version_id,-1) <> pos_structure_version_id
362: and p_position_structure_id = position_structure_id;
363: begin