We are upgrading from 188.8.131.52 to 12.1.3. We are facing an issue with the approval history for the requisition Approval notification.
In 184.108.40.206, the notification included the approvers that will be notified after the current approver. The approvers who had yet to take an action are listed with no action or date.
In 12.1.3, only the approvers who have already approved are displayed. I questioned the need for this information to decide on approval, but users have informed us that they need this information to "prod" the next approver.
In PO_WF_REQ_NOTIFICATION.get_pending_action_html, the following cursor is used to obtain the pending approvers. However, in 12.1.3, po_approval_list_lines and po_approval_list_headers are not populated for requisitions created in R12. The records still exist for the approval lists built in 220.127.116.11. Anyone know if the lists are still built in a way that we can obtain the pending approvers and where the lists are stored?
CURSOR pending_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS
NULL, NULL, NULL /* bug 2788683*/
FROM per_all_people_f per, -- Bug 3404451
WHERE pah.document_id = v_document_id
and pah.document_type = v_object_type
and pah.latest_revision = 'Y'
and pal.APPROVAL_LIST_HEADER_ID = pah.APPROVAL_LIST_HEADER_ID
and pal.STATUS IS NULL
and per.PERSON_ID = pal.APPROVER_ID
and trunc(sysdate) between per.EFFECTIVE_START_DATE
ORDER BY 1 desc;