APPS.MO_GLOBAL dependencies on PER_ORGANIZATION_LIST

Line 75: FROM per_organization_list per

71:
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;

Line 90: -- per_organization_list is not populated, so should directly get the

86: AND hr.usable_flag is null;
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

Line 107: -- For a global view all security profile, the per_organization_list is

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
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