DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on GL_SETS_OF_BOOKS

Line 4413: gl_sets_of_books sob

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)
4417: AND itf.trx_line_id = p_trx_line_id(i)

Line 4432: gl_sets_of_books sob

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)
4436: AND itf.trx_line_id = p_trx_line_id(i)

Line 5351: gl_sets_of_books sob

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)
5355: AND (itf.reverse_flag IS NULL OR itf.reverse_flag <> 'Y')

Line 5373: gl_sets_of_books sob

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)
5377: AND itf.tax_rate = 0