APPS.PO_PARTIAL_FUNDING_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 254: po_requisition_lines_all l,

250: BULK COLLECT INTO l_dist_id_tbl,l_price_tbl,l_match_basis_tbl,l_qty_ordered_tbl,
251: l_amt_ordered_tbl,l_partial_flag_tbl,l_fund_value_tbl,l_nr_tax_tbl,
252: l_rate_tbl,l_qty_funded_tbl,l_amt_funded_tbl,l_func_currency_tbl
253: FROM po_req_distributions_all d,
254: po_requisition_lines_all l,
255: GL_SETS_OF_BOOKS GLSOB
256: WHERE l.requisition_header_id = p_doc_header_id
257: AND l.requisition_line_id = d.requisition_line_id
258: AND Nvl(l.cancel_flag,'N') <> 'Y'

Line 499: FROM po_requisition_lines_all prl, po_req_distributions_all prd

495: req_line_quantity,
496: prl.Unit_Price,
497: Nvl(prd.nonrecoverable_tax,0),
498: source_req_distribution_id
499: FROM po_requisition_lines_all prl, po_req_distributions_all prd
500: WHERE prl.Requisition_Line_Id =p_new_Req_line_id
501: and prd.Requisition_Line_Id = prl.Requisition_Line_Id;
502:
503:

Line 623: po_requisition_lines_all l

619:
620: SELECT Sum(Nvl(funded_value,0))
621: INTO l_funded_value
622: FROM po_req_distributions_all d,
623: po_requisition_lines_all l
624: WHERE d.requisition_line_id = l.requisition_line_id
625: AND l.requisition_line_id = l_line_id;
626: ELSIF l_header_id IS NOT NULL THEN
627: d_progress := 30;

Line 637: po_requisition_lines_all l

633:
634: SELECT Sum(Nvl(funded_value,0))
635: INTO l_funded_value
636: FROM po_req_distributions_all d,
637: po_requisition_lines_all l
638: WHERE d.requisition_line_id = l.requisition_line_id
639: AND l.requisition_header_id = l_header_id;
640: END IF;
641: ELSIF l_doc_type = 'PO' THEN