APPS.POR_APPROVAL_LIST dependencies on PO_REQUISITION_HEADERS

Line 72: from po_requisition_headers_all

68: begin
69:
70: select type_lookup_code
71: into g_document_subtype
72: from po_requisition_headers_all
73: where requisition_header_id = p_document_id;
74:
75: end;
76:

Line 302: FROM po_requisition_headers

298: BEGIN
299:
300: SELECT preparer_id
301: INTO l_preparer_id
302: FROM po_requisition_headers
303: WHERE requisition_header_id = p_document_id;
304:
305: VerifyAuthority(p_document_id=>p_document_id,
306: p_document_type=>g_document_type,

Line 344: FROM po_requisition_headers

340: BEGIN
341:
342: SELECT preparer_id
343: INTO l_preparer_id
344: FROM po_requisition_headers
345: WHERE requisition_header_id = p_document_id;
346:
347: VerifyAuthority(p_document_id=>p_document_id,
348: p_document_type=>g_document_type,

Line 691: UPDATE po_requisition_headers

687: l_wf_item_key VARCHAR2(32767) := to_char(p_document_id) || '-1';
688: l_return NUMBER := 0;
689: BEGIN
690:
691: UPDATE po_requisition_headers
692: SET wf_item_type = 'REQAPPRV',
693: wf_item_key = l_wf_item_key
694: WHERE requisition_header_id = p_document_id;
695:

Line 1082: po_requisition_headers_all prh

1078:
1079: cursor adhoc_approver_c IS
1080: select pal.approver_id
1081: from po_approval_list_lines pal, po_approval_list_headers pah,
1082: po_requisition_headers_all prh
1083: where pal.approval_list_header_id = pah.approval_list_header_id
1084: and pah.latest_revision = 'Y'
1085: and pal.mandatory_flag = 'N'
1086: and approver_type ='USER'