APPS.PA_RESOURCE_UTILS dependencies on PA_MANAGERS_V

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

4503: and rownum = 1; -- to stop multiple rows error
4504: --dbms_output.put_line('mgr id RM - id null ' || x_manager_id);
4505:
4506: ELSE
4507: -- Validates using pa_managers_v when the user's responsibility is
4508: -- Super User or Staffing Manager
4509: select distinct manager_id into x_manager_id
4510: from pa_managers_v
4511: where manager_full_name = l_manager_name;

Line 4510: from pa_managers_v

4506: ELSE
4507: -- Validates using pa_managers_v when the user's responsibility is
4508: -- Super User or Staffing Manager
4509: select distinct manager_id into x_manager_id
4510: from pa_managers_v
4511: where manager_full_name = l_manager_name;
4512: --dbms_output.put_line('mgr id M - id null ' || x_manager_id);
4513: END IF;
4514:

Line 4531: from pa_managers_v

4527: and rownum = 1;
4528: --dbms_output.put_line('mgr id RM - id not null ' || x_manager_id);
4529: ELSE
4530: select distinct manager_id into x_manager_id
4531: from pa_managers_v
4532: where manager_full_name = l_manager_name
4533: and manager_id = l_manager_id;
4534: --dbms_output.put_line('mgr id M - id not null ' || x_manager_id);
4535: END IF;