APPS.PO_DOCUMENT_ACTIONS_SV dependencies on PO_REQUISITION_HEADERS_ALL

Line 55: po_requisition_headers_all.type_lookup_code%TYPE;

51: -- Bulk collect
52: l_id_key NUMBER;
53: -- First their table types
54: TYPE l_doc_sub_type_list_type IS TABLE OF
55: po_requisition_headers_all.type_lookup_code%TYPE;
56: TYPE l_approval_id_list_type IS TABLE OF
57: po_document_types_all.default_approval_path_id%TYPE;
58: TYPE l_org_id_list_type IS TABLE OF
59: po_requisition_headers_all.org_id%TYPE;

Line 59: po_requisition_headers_all.org_id%TYPE;

55: po_requisition_headers_all.type_lookup_code%TYPE;
56: TYPE l_approval_id_list_type IS TABLE OF
57: po_document_types_all.default_approval_path_id%TYPE;
58: TYPE l_org_id_list_type IS TABLE OF
59: po_requisition_headers_all.org_id%TYPE;
60:
61: TYPE l_rowid_char_tbl_type IS TABLE OF VARCHAR2(18);
62: -- The local tables
63: l_doc_sub_type_tbl l_doc_sub_type_list_type;

Line 120: FROM po_requisition_headers_all prh,

116: =
117: ( SELECT prh.type_lookup_code,
118: podc.default_approval_path_id,
119: prh.org_id
120: FROM po_requisition_headers_all prh,
121: po_document_types_all podc
122: WHERE prh.requisition_header_id = p_req_header_id_tbl(i)
123: AND podc.document_type_code = 'REQUISITION'
124: AND podc.document_subtype = prh.type_lookup_code