APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on HR_EMPLOYEES

Line 185: FROM hr_employees hremp

181: , 'Subcontracting Order ' || h.segment1 || '-' || l.line_num || '-' ||
182: loc.shipment_num || ',' || h.revision_num REPORT_TITLE_NUM
183: , h.segment1
184: , (SELECT hremp.full_name
185: FROM hr_employees hremp
186: WHERE hremp.employee_id(+) = h.agent_id
187: AND h.agent_id = nvl(lp_agent_name_num,h.agent_id)) AGENT_NAME
188: , l.line_num
189: , loc.shipment_num

Line 259: hr_employees hremp

255: 1,
256: ( SELECT hremp.full_name || ' ' || hrloc.location_code
257: FROM po_distributions_all d,
258: hr_locations_all hrloc,
259: hr_employees hremp
260: WHERE hrloc.location_id(+) = d.deliver_to_location_id AND
261: hremp.employee_id(+) = d.deliver_to_person_id AND
262: d.line_location_id = sub.subcontract_po_shipment_id),
263: -- 'MANY REQUESTOR')