APPS.MO_GLOBAL dependencies on HR_OPERATING_UNITS

Line 76: , hr_operating_units hr

72: CURSOR c1 IS
73: SELECT per.organization_id organization_id
74: , hr.NAME name
75: FROM per_organization_list per
76: , hr_operating_units hr
77: WHERE per.security_profile_id = to_number(p_sp_id_char)
78: AND hr.organization_id = per.organization_id
79: AND hr.usable_flag is null;
80:

Line 84: FROM hr_operating_units hr

80:
81: CURSOR c2 IS
82: SELECT hr.organization_id organization_id
83: , hr.name name
84: FROM hr_operating_units hr
85: WHERE hr.organization_id = to_number(p_org_id_char)
86: AND hr.usable_flag is null;
87:
88: -- Added the following cursor to support view all security profile with a

Line 91: -- operating units for the particular business group from hr_operating_units

87:
88: -- Added the following cursor to support view all security profile with a
89: -- business group (BG). For a view all security profile within a BG, the
90: -- per_organization_list is not populated, so should directly get the
91: -- operating units for the particular business group from hr_operating_units
92: -- view.
93:
94: -- Commented out the reference of the business group name in the WHERE
95: -- Clause, since the SQL is supposed to return all operating units under

Line 102: FROM hr_operating_units hr

98: CURSOR c3 (X_sp_name VARCHAR2,
99: X_bg_id NUMBER) IS
100: SELECT hr.organization_id organization_id
101: , hr.name name
102: FROM hr_operating_units hr
103: WHERE hr.business_group_id = X_bg_id
104: AND hr.usable_flag is null;
105:
106: -- Added the following cursor to support global view all security profile

Line 109: -- hr_operating_units view.

105:
106: -- Added the following cursor to support global view all security profile
107: -- For a global view all security profile, the per_organization_list is
108: -- not populated, so should directly get all operating units from
109: -- hr_operating_units view.
110:
111: CURSOR c4 IS
112: SELECT hr.organization_id organization_id
113: , hr.name name

Line 114: FROM hr_operating_units hr

110:
111: CURSOR c4 IS
112: SELECT hr.organization_id organization_id
113: , hr.name name
114: FROM hr_operating_units hr
115: WHERE hr.usable_flag is null;
116:
117: -- Added the following cursor to support synchronization with the multi-org
118: -- preference setup.

Line 128: l_del_org_id hr_operating_units.organization_id%TYPE;

124: AND RESP_ID = FND_GLOBAL.RESP_ID;
125:
126: l_user_id number;
127: l_resp_id number;
128: l_del_org_id hr_operating_units.organization_id%TYPE;
129:
130: BEGIN
131:
132: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 580: l_current_org_id hr_operating_units.name%TYPE;

576: l_access_ctrl_enabled VARCHAR2(1);
577: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := p_sp_id_char;
578: l_org_id fnd_profile_option_values.profile_option_value%TYPE := p_org_id_char;
579:
580: l_current_org_id hr_operating_units.name%TYPE;
581: l_view_all_orgs VARCHAR2(1);
582:
583: NO_SP_OU_FOUND EXCEPTION;
584: NO_ORG_ACCESS_FOUND EXCEPTION;