DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_APPROVAL_LIST_LINES

Line 1842: po_approval_list_lines pal,

1838: CURSOR pending_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS
1839:
1840: SELECT pal.SEQUENCE_NUM,per.FULL_NAME,null,null,null,null
1841: FROM per_people_f per,
1842: po_approval_list_lines pal,
1843: po_approval_list_headers pah
1844: WHERE pah.document_id = v_document_id
1845: and pah.document_type = v_object_type
1846: and pah.latest_revision = 'Y'