APPS.PO_TAX_SUMMARY_PKG dependencies on PO_REQUISITION_LINES

Line 110: po_requisition_lines prl

106: if (object_location = 'HEADER') then
107: SELECT nvl(SUM(prd.recoverable_tax), 0)
108: into X_recoverable_tax
109: FROM po_req_distributions prd,
110: po_requisition_lines prl
111: WHERE prd.requisition_line_id = prl.requisition_line_id
112: AND prl.requisition_header_id = x_header_id
113: AND nvl(prl.cancel_flag, 'N') <> 'Y'
114: AND nvl(prl.closed_code, 'OPEN') <> 'FINALLY CLOSED';

Line 229: po_requisition_lines prl

225: if (object_location = 'HEADER') then
226: SELECT nvl(SUM(prd.nonrecoverable_tax), 0)
227: into X_nonrecoverable_tax
228: FROM po_req_distributions prd,
229: po_requisition_lines prl
230: WHERE prd.requisition_line_id = prl.requisition_line_id
231: AND prl.requisition_header_id = x_header_id
232: AND nvl(prl.cancel_flag, 'N') <> 'Y'
233: AND nvl(prl.closed_code, 'OPEN') <> 'FINALLY CLOSED';

Line 419: FROM po_requisition_lines

415: SELECT nvl(SUM(round(decode(order_type_lookup_code,'RATE',amount,'FIXED PRICE', amount,
416: unit_price * quantity)/X_min_acct_unit)
417: *X_min_acct_unit), 0) -- SERVICES FPJ
418: into X_header_amount
419: FROM po_requisition_lines
420: WHERE requisition_header_id = x_header_id
421: AND nvl(cancel_flag, 'N') <> 'Y'
422: AND nvl(closed_code, 'OPEN') <> 'FINALLY CLOSED';
423:

Line 428: FROM po_requisition_lines

424: else
425: SELECT nvl(SUM(round(decode(order_type_lookup_code,'RATE',amount,'FIXED PRICE', amount,
426: unit_price * quantity),X_precision)), 0) -- SERVICES FPJ
427: into X_header_amount
428: FROM po_requisition_lines
429: WHERE requisition_header_id = x_header_id;
430:
431: end if;
432: