DBA Data[Home] [Help]

APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on HR_EMPLOYEES

Line 1336: HR_EMPLOYEES RE

1332: INTO ORDER_NUMBER,REQ_NAME
1333: FROM
1334: OE_ORDER_HEADERS_ALL BH,
1335: PO_REQUISITION_HEADERS_ALL RH,
1336: HR_EMPLOYEES RE
1337: WHERE RH.TYPE_LOOKUP_CODE = 'INTERNAL'
1338: AND RH.PREPARER_ID = RE.EMPLOYEE_ID
1339: AND BH.HEADER_ID = ATTACH_ORDER_ID
1340: AND BH.SOURCE_DOCUMENT_ID = RH.REQUISITION_HEADER_ID

Line 1348: HR_EMPLOYEES re

1344: into order_number, req_name
1345: from oe_order_HEADERS_ALL bh,
1346: oe_order_lines_all ool,
1347: po_requisition_lines_all pll,
1348: HR_EMPLOYEES re
1349: where pll.SOURCE_TYPE_CODE = 'INVENTORY'
1350: AND pll.to_person_id = re.employee_id
1351: and bh.header_id = ool.header_id
1352: and ool.SOURCE_DOCUMENT_LINE_ID = pll.REQUISITION_LINE_ID