APPS.HRI_BPL_ORG dependencies on PER_SECURITY_PROFILES

Line 19: per_security_profiles.organization_structure_id%TYPE;

15: g_Sup_Organization_id hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE := -1;
16:
17: /* define globals for testing if a user can see certain org hrcy versions */
18: g_organization_structure_id
19: per_security_profiles.organization_structure_id%TYPE;
20:
21:
22: /******************************************************************************/
23: /* Empties and repopulates the global cache for the values passed in */

Line 108: per_security_profiles.organization_structure_id%TYPE;

104: -- if none is attached, returns -1
105: FUNCTION get_org_structure_id RETURN NUMBER IS
106:
107: l_organization_structure_id
108: per_security_profiles.organization_structure_id%TYPE;
109:
110: -- to get the value of the organization hierarchy structure id
111: -- associated with this security profile (if any)
112: CURSOR csr_get_security_profile(p_security_profile_id NUMBER) IS

Line 114: FROM per_security_profiles

110: -- to get the value of the organization hierarchy structure id
111: -- associated with this security profile (if any)
112: CURSOR csr_get_security_profile(p_security_profile_id NUMBER) IS
113: SELECT organization_structure_id
114: FROM per_security_profiles
115: WHERE security_profile_id = p_security_profile_id;
116:
117:
118: BEGIN