APPS.POREQ dependencies on HR_EMPLOYEES_CURRENT_V

Line 103: FROM hr_employees_current_v hrec,

99: --
100: cursor GetApproverPos( b_employee_id number, b_approval_path_id number ) is
101: --
102: SELECT poeh.superior_id forward_to_id
103: FROM hr_employees_current_v hrec,
104: po_employee_hierarchies poeh
105: WHERE poeh.position_structure_id = b_approval_path_id
106: AND poeh.employee_id = b_employee_id
107: AND hrec.employee_id = poeh.superior_id

Line 165: hr_employees_current_v hremp

161: cursor GetApproverPos( b_employee_id number, b_approval_path_id number ) is
162: --
163: SELECT poeh.superior_id
164: FROM po_employee_hierarchies poeh,
165: hr_employees_current_v hremp
166: WHERE poeh.employee_id = b_employee_id
167: AND poeh.position_structure_id = b_approval_path_id
168: AND poeh.superior_level = 1
169: AND hremp.employee_id = poeh.superior_id

Line 176: FROM hr_employees_current_v hremp

172: --
173: cursor GetApproverSup ( b_employee_id number ) is
174: --
175: SELECT hremp.supervisor_id
176: FROM hr_employees_current_v hremp
177: WHERE hremp.employee_id = b_employee_id;
178: --
179: begin
180: --