APPS.PO_TAX_SUMMARY_PKG dependencies on PO_REQ_DISTRIBUTIONS

Line 109: FROM po_req_distributions prd,

105: elsif (object_type = 'REQ') then
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'

Line 118: FROM po_req_distributions

114: AND nvl(prl.closed_code, 'OPEN') <> 'FINALLY CLOSED';
115: elsif (object_location = 'LINE') then
116: SELECT nvl(SUM(recoverable_tax), 0)
117: into X_recoverable_tax
118: FROM po_req_distributions
119: WHERE requisition_line_id = X_line_id;
120: end if;
121: end if;
122: RETURN (X_recoverable_tax);

Line 228: FROM po_req_distributions prd,

224: elsif (object_type = 'REQ') then
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'

Line 237: FROM po_req_distributions

233: AND nvl(prl.closed_code, 'OPEN') <> 'FINALLY CLOSED';
234: elsif (object_location = 'LINE') then
235: SELECT nvl(SUM(nonrecoverable_tax), 0)
236: into X_nonrecoverable_tax
237: FROM po_req_distributions
238: WHERE requisition_line_id = X_line_id;
239: end if;
240: end if;
241: RETURN (X_nonrecoverable_tax);