APPS.ZX_JL_EXTRACT_PKG dependencies on FND_CURRENCIES

Line 4412: fnd_currencies cur,

4408: ) *
4409: NVL(cur.minimum_accountable_unit,power(10,(-1 * cur.precision)))
4410: INTO l_taxable_amt_tbl(k)
4411: FROM zx_rep_trx_detail_t itf,
4412: fnd_currencies cur,
4413: gl_sets_of_books sob
4414: WHERE itf.request_id = p_request_id
4415: AND itf.trx_id = p_trx_id_tbl(i)
4416: AND itf.detail_tax_line_id = p_detail_tax_line_id(i)

Line 4431: fnd_currencies cur,

4427: ) *
4428: NVL(cur.minimum_accountable_unit,power(10,(-1 * cur.precision)))
4429: INTO l_taxable_amt_tbl(k)
4430: FROM zx_rep_trx_detail_t itf,
4431: fnd_currencies cur,
4432: gl_sets_of_books sob
4433: WHERE itf.request_id = p_request_id
4434: AND itf.trx_id = p_trx_id_tbl(i)
4435: AND itf.detail_tax_line_id = p_detail_tax_line_id(i)

Line 5350: fnd_currencies cur,

5346: ) *
5347: NVL(cur.minimum_accountable_unit,power(10,(-1 * cur.precision)))
5348: INTO l_vat_exempt_amt_tbl(p_trx_id_tbl(i))
5349: FROM zx_rep_trx_detail_t itf,
5350: fnd_currencies cur,
5351: gl_sets_of_books sob
5352: WHERE itf.request_id = p_request_id
5353: AND itf.trx_id = p_trx_id_tbl(i)
5354: AND itf.detail_tax_line_id = p_detail_tax_line_id(i)

Line 5372: fnd_currencies cur,

5368: ) *
5369: NVL(cur.minimum_accountable_unit,power(10,(-1 * cur.precision)))
5370: INTO l_vat_exempt_amt_tbl(p_trx_id_tbl(i))
5371: FROM zx_rep_trx_detail_t itf,
5372: fnd_currencies cur,
5373: gl_sets_of_books sob
5374: WHERE itf.request_id = p_request_id
5375: AND itf.trx_id = p_trx_id_tbl(i)
5376: AND itf.detail_tax_line_id = p_detail_tax_line_id(i)

Line 8656: SET gdf_fnd_currencies_att1= (SELECT global_attribute1

8652: 'UPDATE_DGI_CURR_CODE(+)');
8653: END IF;
8654:
8655: UPDATE zx_rep_trx_detail_t dtl
8656: SET gdf_fnd_currencies_att1= (SELECT global_attribute1
8657: FROM fnd_currencies
8658: WHERE currency_code = dtl.trx_currency_code)
8659: WHERE request_id = p_request_id;
8660:

Line 8657: FROM fnd_currencies

8653: END IF;
8654:
8655: UPDATE zx_rep_trx_detail_t dtl
8656: SET gdf_fnd_currencies_att1= (SELECT global_attribute1
8657: FROM fnd_currencies
8658: WHERE currency_code = dtl.trx_currency_code)
8659: WHERE request_id = p_request_id;
8660:
8661: IF (g_level_procedure >= g_current_runtime_level ) THEN