Line 122: OPEN csr_get_security_profile(hr_security.get_security_profile);
118: BEGIN
119:
120: -- get the organization hierarchy associated with that
121: -- security profile 122: OPEN csr_get_security_profile(hr_security.get_security_profile); 123: FETCH csr_get_security_profile INTO l_organization_structure_id;
124: CLOSE csr_get_security_profile;
125:
126: RETURN(NVL(l_organization_structure_id,-1));