157: pah.approval_path_id
158: INTO x_approval_path,
159: x_approval_path_id
160: FROM per_position_structures pps,
161: po_action_history pah
162: WHERE pah.approval_path_id = pps.position_structure_id
163: AND pah.object_id = x_object_id
164: AND pah.object_type_code = x_document_type_code
165: AND pah.object_sub_type_code = x_document_subtype
164: AND pah.object_type_code = x_document_type_code
165: AND pah.object_sub_type_code = x_document_subtype
166: AND pah.sequence_num =
167: (SELECT max(sequence_num)
168: FROM po_action_history PAH2
169: WHERE PAH2.object_id = x_object_id
170: AND PAH2.object_type_code = x_document_type_code
171: AND PAH2.object_sub_type_code = x_document_subtype
172: AND PAH2.action_code is not null);