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 508: l_current_org_id hr_operating_units.name%TYPE;

504: l_access_ctrl_enabled VARCHAR2(1);
505: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := p_sp_id_char;
506: l_org_id fnd_profile_option_values.profile_option_value%TYPE := p_org_id_char;
507:
508: l_current_org_id hr_operating_units.name%TYPE;
509: l_view_all_orgs VARCHAR2(1);
510:
511: NO_SP_OU_FOUND EXCEPTION;
512: NO_ORG_ACCESS_FOUND EXCEPTION;