APPS.PO_MOD_CONTROL_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 293: FROM po_headers_draft_all phd, po_requisition_headers_all prh

289: last_update_login = FND_GLOBAL.LOGIN_ID
290: WHERE par_line_id IS NULL
291: AND clm_info_flag = 'Y'
292: AND par_draft_id = ( SELECT phd.draft_id
293: FROM po_headers_draft_all phd, po_requisition_headers_all prh
294: WHERE phd.mod_draft_id = p_draft_id
295: AND prh.requisition_header_id = prl.requisition_header_id
296: AND Nvl(prh.par_flag, 'N') = 'Y'
297: );

Line 1116: l_req_authorization_status po_requisition_headers_all.authorization_status%TYPE;

1112: l_online_report_id NUMBER;
1113: l_return_code VARCHAR2(25);
1114: l_error_message VARCHAR2(2000);
1115: l_req_header_id NUMBER;
1116: l_req_authorization_status po_requisition_headers_all.authorization_status%TYPE;
1117: l_approval_id NUMBER;
1118: l_item_key_tbl PO_TBL_VARCHAR100;
1119: l_item_status VARCHAR2(10);
1120: l_result VARCHAR2(10);

Line 1161: FROM po_requisition_headers_all prh,

1157: INTO l_req_header_id,
1158: l_approval_id,
1159: l_req_authorization_status,
1160: l_org_id
1161: FROM po_requisition_headers_all prh,
1162: po_document_types_all podc
1163: WHERE prh.segment1 = To_char(p_draft_id)
1164: AND podc.document_type_code = 'REQUISITION'
1165: AND podc.document_subtype = prh.type_lookup_code