161: AND NVL(modified_by_agent_flag, 'N') = 'N';
162: cursor req_tax_csr(p_doc_id number) is
163: SELECT nvl(sum(nonrecoverable_tax), 0)
164: FROM po_requisition_lines_all rl,
165: po_req_distributions_all rd
166: WHERE rl.requisition_header_id = p_doc_id
167: AND rd.requisition_line_id = rl.requisition_line_id
168: AND NVL(rl.cancel_flag,'N') = 'N'
169: AND NVL(rl.modified_by_agent_flag, 'N') = 'N';
333:
334: SELECT nvl(sum(nonrecoverable_tax), 0)
335: INTO l_tax_amt
336: FROM po_requisition_lines rl,
337: po_req_distributions_all rd --
339: AND rd.requisition_line_id = rl.requisition_line_id;
340:
341: if (display_type = 'text/html') then
598:
599: SELECT nvl(sum(nonrecoverable_tax), 0)
600: INTO l_tax_amt
601: FROM po_requisition_lines rl,
602: po_req_distributions_all rd --
604: AND rd.requisition_line_id = rl.requisition_line_id;
605:
606: if (display_type = 'text/html') then
840:
841: SELECT nvl(sum(nonrecoverable_tax), 0)
842: INTO l_tax_amt
843: FROM po_requisition_lines rl,
844: po_req_distributions_all rd --
846: AND rd.requisition_line_id = rl.requisition_line_id;
847:
848: if (display_type = 'text/html') then
1066:
1067: SELECT nvl(sum(nonrecoverable_tax), 0)
1068: INTO l_tax_amt
1069: FROM po_requisition_lines rl,
1070: po_req_distributions_all rd --
1072: AND rd.requisition_line_id = rl.requisition_line_id;
1073:
1074: if (display_type = 'text/html') then
1494: ORDER BY rql.line_num;
1495:
1496: CURSOR ccId_csr(req_line_id NUMBER) IS
1497: SELECT CODE_COMBINATION_ID
1498: FROM PO_REQ_DISTRIBUTIONS_ALL
1499: WHERE REQUISITION_LINE_ID = req_line_id;
1500:
1501: l_notification_id number;
1502: