APPS.POREQ dependencies on PO_REQUISITION_HEADERS

Line 40: FROM po_requisition_headers porh,

36: podt.forwarding_mode_code,
37: nvl(podt.default_approval_path_id,0),
38: nvl(can_preparer_approve_flag,'N')
39: INTO p_req_info
40: FROM po_requisition_headers porh,
41: po_document_types podt
42: WHERE porh.requisition_header_id = p_requisition_header_id
43: AND podt.document_type_code = 'REQUISITION'
44: AND podt.document_subtype = porh.type_lookup_code;

Line 59: po_requisition_headers porh

55: --
56: SELECT nvl(poac.employee_id,porh.preparer_id)
57: INTO l_employee_id
58: FROM po_action_history poac,
59: po_requisition_headers porh
60: WHERE porh.requisition_header_id = p_requisition_header_id
61: AND porh.requisition_header_id = poac.object_id(+)
62: AND poac.object_type_code(+) = 'REQUISITION'
63: AND poac.action_code is null;