APPS.PA_RESOURCE_UTILS dependencies on PA_MANAGERS_V

Line 4171: -- Validates using pa_managers_v when the user's responsibility is

4167: and rownum = 1; -- to stop multiple rows error
4168: --dbms_output.put_line('mgr id RM - id null ' || x_manager_id);
4169:
4170: ELSE
4171: -- Validates using pa_managers_v when the user's responsibility is
4172: -- Super User or Staffing Manager
4173: select distinct manager_id into x_manager_id
4174: from pa_managers_v
4175: where manager_full_name = l_manager_name;

Line 4174: from pa_managers_v

4170: ELSE
4171: -- Validates using pa_managers_v when the user's responsibility is
4172: -- Super User or Staffing Manager
4173: select distinct manager_id into x_manager_id
4174: from pa_managers_v
4175: where manager_full_name = l_manager_name;
4176: --dbms_output.put_line('mgr id M - id null ' || x_manager_id);
4177: END IF;
4178:

Line 4195: from pa_managers_v

4191: and rownum = 1;
4192: --dbms_output.put_line('mgr id RM - id not null ' || x_manager_id);
4193: ELSE
4194: select distinct manager_id into x_manager_id
4195: from pa_managers_v
4196: where manager_full_name = l_manager_name
4197: and manager_id = l_manager_id;
4198: --dbms_output.put_line('mgr id M - id not null ' || x_manager_id);
4199: END IF;