DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on HR_EMPLOYEES

Line 198: FROM hr_employees hremp

194: , h.segment1 || '-' || l.line_num || '-' ||
195: loc.shipment_num || ',' || h.revision_num REPORT_TITLE_NUM
196: , h.segment1
197: , (SELECT hremp.full_name
198: FROM hr_employees hremp
199: WHERE hremp.employee_id(+) = h.agent_id
200: AND h.agent_id = nvl(lp_agent_name_num,h.agent_id)) AGENT_NAME
201: , l.line_num
202: , loc.shipment_num

Line 272: hr_employees hremp

268: 1,
269: ( SELECT hremp.full_name || ' ' || hrloc.location_code
270: FROM po_distributions_all d,
271: hr_locations_all hrloc,
272: hr_employees hremp
273: WHERE hrloc.location_id(+) = d.deliver_to_location_id AND
274: hremp.employee_id(+) = d.deliver_to_person_id AND
275: d.line_location_id = sub.subcontract_po_shipment_id),
276: -- 'MANY REQUESTOR')