APPS.PO_DOCUMENT_ACTIONS_SV dependencies on PO_DOCUMENT_TYPES_ALL

Line 57: po_document_types_all.default_approval_path_id%TYPE;

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;
60:
61: TYPE l_rowid_char_tbl_type IS TABLE OF VARCHAR2(18);

Line 121: po_document_types_all podc

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
125: AND podc.org_id = prh.org_id --