DBA Data[Home] [Help]

APPS.POR_APPROVAL_LIST dependencies on PO_REQUISITION_HEADERS_ALL

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