APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_REQUISITION_LINES

Line 4688: FROM po_requisition_lines

4684: /*Start Bug#3406460 - Added precision parameter to round the line amount*/
4685: CURSOR req_total_csr(p_doc_id NUMBER,l_precision NUMBER)
4686: IS
4687: SELECT NVL(SUM(ROUND(DECODE(order_type_lookup_code, 'RATE', amount, 'FIXED PRICE', amount, quantity * unit_price),l_precision)) ,0)
4688: FROM po_requisition_lines
4689: WHERE requisition_header_id = p_doc_id
4690: AND NVL(cancel_flag,'N') = 'N'
4691: AND NVL(modified_by_agent_flag, 'N') = 'N';
4692: /*End Bug#3406460*/

Line 4701: FROM po_requisition_lines rl,

4697: */
4698: CURSOR req_tax_csr(p_doc_id NUMBER)
4699: IS
4700: SELECT NVL(SUM(nonrecoverable_tax), 0)
4701: FROM po_requisition_lines rl,
4702: po_req_distributions_all rd --
4703: WHERE rl.requisition_header_id = p_doc_id
4704: AND rd.requisition_line_id = rl.requisition_line_id
4705: AND NVL(rl.cancel_flag,'N') = 'N'