DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on PO_APPROVAL_LIST_LINES

Line 2166: po_approval_list_lines pal,

2162:
2163: SELECT pal.SEQUENCE_NUM,per.FULL_NAME,null,null,null,null,
2164: NULL, NULL, NULL /* bug 2788683*/
2165: FROM per_all_people_f per, -- Bug 3404451
2166: po_approval_list_lines pal,
2167: po_approval_list_headers pah
2168: WHERE pah.document_id = v_document_id
2169: and pah.document_type = v_object_type
2170: and pah.latest_revision = 'Y'

Line 2181: po_approval_list_lines pal,

2177:
2178: CURSOR count_rows(v_document_id NUMBER, v_object_type VARCHAR2) IS
2179: SELECT count(*)
2180: FROM per_all_people_f per,
2181: po_approval_list_lines pal,
2182: po_approval_list_headers pah
2183: WHERE pah.document_id = v_document_id
2184: and pah.document_type = v_object_type
2185: and pah.latest_revision = 'Y'