DBA Data[Home] [Help]

APPS.POR_APPROVAL_LIST dependencies on PO_REQUISITION_HEADERS_ALL

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 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'