APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_REQUISITION_LINES

Line 5540: FROM po_requisition_lines

5536: SELECT nvl(SUM(round(decode(order_type_lookup_code,
5537: 'RATE', amount,
5538: 'FIXED PRICE', amount,
5539: quantity * unit_price),l_precision)) ,0)
5540: FROM po_requisition_lines
5541: WHERE requisition_header_id = p_doc_id
5542: AND NVL(cancel_flag,'N') = 'N'
5543: AND NVL(modified_by_agent_flag, 'N') = 'N';
5544: /*End Bug#3406460*/

Line 5553: FROM po_requisition_lines rl,

5549: */
5550:
5551: cursor req_tax_csr(p_doc_id number) is
5552: SELECT nvl(sum(nonrecoverable_tax), 0)
5553: FROM po_requisition_lines rl,
5554: po_req_distributions_all rd --
5555: WHERE rl.requisition_header_id = p_doc_id
5556: AND rd.requisition_line_id = rl.requisition_line_id
5557: AND NVL(rl.cancel_flag,'N') = 'N'