APPS.PO_MODIFY_REQUISITION_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 338: Po_Requisition_Headers_All prha

334: PRHA.FEDERAL_FLAG,
335: prl_2.LINE_NUM_DISPLAY
336: FROM po_requisition_lines_all prl_1,
337: po_requisition_lines_all prl_2,
338: Po_Requisition_Headers_All prha
339: WHERE prl_1.requisition_line_id = p_req_line_id
340: AND prha.Requisition_Header_Id = prl_1.Requisition_Header_Id
341: AND prl_2.Requisition_Line_Id = NVL(prl_1.GROUP_LINE_ID,p_req_line_id)
342: FOR UPDATE OF prl_1.quantity NOWAIT;

Line 488: -- FROM Po_Requisition_Headers_All

484: -- Retrieve federalFlag and copy it to l_is_federal_flag
485:
486: -- SELECT Federal_Flag
487: -- INTO l_is_federal_flag
488: -- FROM Po_Requisition_Headers_All
489: -- WHERE Requisition_Header_Id=L_Temp_Req_Header_Id;
490:
491: --if it is a CLM document
492: IF l_is_federal_flag ='Y' THEN