APPS.PO_TOTALS_PO_SV dependencies on FND_CURRENCIES

Line 18: FROM fnd_currencies fc,

14: SELECT nvl(fc.minimum_accountable_unit,1),
15: fc.precision
16: INTO x_min_unit,
17: x_precision
18: FROM fnd_currencies fc,
19: po_headers ph
20: WHERE ph.po_header_id = X_header_id
21: AND fc.currency_code = ph.currency_code;
22:

Line 58: FROM fnd_currencies fc,

54: SELECT nvl(fc.minimum_accountable_unit,1),
55: fc.precision
56: INTO x_min_unit,
57: x_precision
58: FROM fnd_currencies fc,
59: po_headers_archive pha
60: WHERE pha.po_header_id = X_header_id
61: AND pha.revision_num = X_revision_num
62: AND fc.currency_code = pha.currency_code;

Line 108: FROM fnd_currencies fc,

104: SELECT nvl(fc.minimum_accountable_unit,1),
105: fc.precision
106: INTO x_min_unit,
107: x_precision
108: FROM fnd_currencies fc,
109: po_headers_archive pha,
110: po_releases_archive pra
111: WHERE pha.po_header_id = pra.po_header_id
112: AND pra.po_release_id = X_release_id

Line 160: FROM fnd_currencies fc,

156: SELECT nvl(fc.minimum_accountable_unit,1),
157: fc.precision
158: INTO x_min_unit,
159: x_precision
160: FROM fnd_currencies fc,
161: po_headers ph,
162: po_releases pr
163: WHERE ph.po_header_id = pr.po_header_id
164: AND pr.po_release_id = X_release_id