APPS.POR_APPROVAL_LIST dependencies on PO_REQUISITION_HEADERS

Line 68: from po_requisition_headers_all

64: begin
65:
66: select type_lookup_code
67: into g_document_subtype
68: from po_requisition_headers_all
69: where requisition_header_id = p_document_id;
70:
71: end;
72:

Line 257: FROM po_requisition_headers

253: BEGIN
254:
255: SELECT preparer_id
256: INTO l_preparer_id
257: FROM po_requisition_headers
258: WHERE requisition_header_id = p_document_id;
259:
260: VerifyAuthority(p_document_id=>p_document_id,
261: p_document_type=>g_document_type,

Line 299: FROM po_requisition_headers

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

Line 646: UPDATE po_requisition_headers

642: l_wf_item_key VARCHAR2(32767) := to_char(p_document_id) || '-1';
643: l_return NUMBER := 0;
644: BEGIN
645:
646: UPDATE po_requisition_headers
647: SET wf_item_type = 'REQAPPRV',
648: wf_item_key = l_wf_item_key
649: WHERE requisition_header_id = p_document_id;
650:

Line 1037: po_requisition_headers_all prh

1033:
1034: cursor adhoc_approver_c IS
1035: select pal.approver_id
1036: from po_approval_list_lines pal, po_approval_list_headers pah,
1037: po_requisition_headers_all prh
1038: where pal.approval_list_header_id = pah.approval_list_header_id
1039: and pah.latest_revision = 'Y'
1040: and pal.mandatory_flag = 'N'
1041: and approver_type ='USER'