APPS.PER_OSV_BUS dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 63: update per_org_structure_versions osv

59: --
60: -- Close down the open structure versions
61: --
62:
63: update per_org_structure_versions osv
64: set osv.date_to = (p_date_from - 1)
65: where osv.organization_structure_id = p_organization_Structure_Id
66: and osv.date_to is null
67: and osv.org_structure_version_id

Line 120: from per_org_structure_versions

116: -- Declare cursor
117: --
118: cursor csr_org_version is
119: select org_structure_version_id,business_group_id
120: from per_org_structure_versions
121: where version_number = p_version_number
122: and nvl(p_org_structure_version_id,-1) <> org_structure_version_id
123: and p_organization_structure_id = organization_structure_id;
124: begin

Line 274: from per_org_structure_versions osv

270: --
271: p_gap_warning := FALSE;
272: select max(osv.date_to)
273: into l_max_end_date
274: from per_org_structure_versions osv
275: where osv.date_from < p_Date_From
276: and osv.organization_structure_id = p_organization_structure_id
277: and osv.org_structure_Version_id = nvl(p_org_structure_version_id,-1);
278: --

Line 283: from per_org_structure_versions osv

279: if (l_max_end_date is not null and p_Date_from = (l_max_end_date +1)
280: or (l_max_end_date is null)) then
281: select min(osv.date_from)
282: into l_min_start_date
283: from per_org_structure_versions osv
284: where osv.organization_structure_id = p_organization_structure_id
285: and osv.date_from > p_Date_To
286: and osv.org_structure_Version_id = nvl(p_org_structure_version_id,-1);
287: --

Line 304: from per_org_structure_versions osv

300: into l_dummy
301: from dual
302: where exists
303: (select 1
304: from per_org_structure_versions osv
305: where osv.date_from <= nvl(p_Date_To, hr_api.g_eot)
306: and nvl(osv.date_to,hr_api.g_eot) >= p_Date_From
307: and osv.organization_structure_id = p_organization_structure_id
308: and osv.org_structure_version_id

Line 337: , per_org_structure_versions osv

333: --
334: cursor csr_sec_grp is
335: select pbg.security_group_id
336: from per_business_groups pbg
337: , per_org_structure_versions osv
338: where osv.org_structure_version_id = p_org_structure_version_id
339: and pbg.business_group_id = osv.business_group_id;
340: --
341: -- Declare local variables

Line 397: , per_org_structure_versions osv

393: --
394: cursor csr_leg_code is
395: select pbg.legislation_code
396: from per_business_groups pbg
397: , per_org_structure_versions osv
398: where osv.org_structure_version_id = p_org_structure_version_id
399: and pbg.business_group_id (+) = osv.business_group_id;
400: --
401: -- Declare local variables