APPS.PA_HR_ORG_UTILS dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 30: FROM per_org_structure_versions POSV1

26: ( p_org_hierarchy_version_id <> FND_API.G_MISS_NUM)) THEN
27: IF (p_check_id_flag = 'Y') THEN
28: SELECT POSV1.org_structure_version_id
29: INTO x_org_hierarchy_version_id
30: FROM per_org_structure_versions POSV1
31: WHERE POSV1.org_structure_version_id
32: = p_org_hierarchy_version_id;
33: ELSE
34: x_org_hierarchy_version_id := p_org_hierarchy_version_id;

Line 40: per_org_structure_versions POSV1

36: ELSE
37: SELECT POSV1.org_structure_version_id
38: INTO x_org_hierarchy_version_id
39: FROM per_organization_structures POS,
40: per_org_structure_versions POSV1
41: WHERE POS.name = p_org_hierarchy_name
42: AND POS.organization_structure_id =
43: POSV1.organization_structure_id;
44: END IF;