APPS.PER_PSE_BUS dependencies on PER_POS_STRUCTURE_VERSIONS

Line 302: from per_pos_structure_versions psv

298: from per_security_profiles psp
299: where psp.business_group_id + 0 = p_Business_Group_Id
300: and psp.position_id = p_Subordinate_position_Id
301: and psp.position_structure_id = (select psv.position_structure_id
302: from per_pos_structure_versions psv
303: where psv.Pos_Structure_version_Id
304: = p_Pos_Structure_version_Id)
305: );
306: --

Line 322: -- exists in per_pos_structure_versions for the business group on the

318: -- |--------------------< chk_pos_structure_version_id >------------------------|
319: -- -----------------------------------------------------------------------------
320: -- Description:
321: -- Validates that the mandatory structure version id is supplied and that it
322: -- exists in per_pos_structure_versions for the business group on the
323: -- effective date (Insert Only).
324: --
325: -- Pre-conditions:
326: -- Business group is valid

Line 335: -- If a row does exist in per_pos_structure_versions for the given id and

331: -- p_pos_structure_version_id
332: -- p_effective_date
333: --
334: -- Post Success:
335: -- If a row does exist in per_pos_structure_versions for the given id and
336: -- business group then processing continues.
337: --
338: -- Post Failure:
339: -- Processing stops and an error is raised.

Line 351: from per_pos_structure_versions psv

347: ,p_effective_date in DATE) IS
348:
349: CURSOR csr_pos_structure_versions IS
350: SELECT 'X'
351: from per_pos_structure_versions psv
352: where psv.pos_structure_version_id = p_pos_structure_version_id
353: and psv.business_group_id = p_business_group_id
354: and p_effective_date between psv.DATE_FROM
355: and nvl(psv.DATE_TO,hr_general.end_of_time);