APPS.HRI_BPL_ORG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 138: per_org_structure_versions.org_structure_version_id%type)

134: -- (including all of its versions, if it has more than one version)
135: --b)if it does not, then show all organization hierarchy versions
136:
137: FUNCTION exist_orghvrsn_for_security(p_org_structure_version_id
138: per_org_structure_versions.org_structure_version_id%type)
139: RETURN VARCHAR2 IS
140:
141: l_check_org_vrsn NUMBER;
142:

Line 146: FROM per_org_structure_versions

142:
143: CURSOR csr_check_hrchy_vrsn(p_organization_structure_id NUMBER
144: ,p_org_structure_version_id NUMBER) IS
145: SELECT 1
146: FROM per_org_structure_versions
147: WHERE organization_structure_id = p_organization_structure_id
148: AND org_structure_version_id = p_org_structure_version_id;
149:
150:

Line 197: per_org_structure_versions.organization_structure_id%type)

193: --a)if it does, then only show that organization hiearchy in the list
194: --b)if it does not then show all organization hierarchies
195:
196: FUNCTION exist_orgh_for_security(p_organization_structure_id
197: per_org_structure_versions.organization_structure_id%type)
198: RETURN VARCHAR2 IS
199:
200: BEGIN
201: