DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on ZX_REP_ACTG_EXT_T

Line 1714: FROM zx_rep_actg_ext_t actg

1710: AND (NVL(itf.reverse_flag,'N') = 'Y'
1711: OR itf.tax_type_code <> NVL(p_trl_global_variables_rec.per_tax_type_code_high,
1712: p_trl_global_variables_rec.per_tax_type_code_low));
1713: /*AND NOT EXISTS ( SELECT 1
1714: FROM zx_rep_actg_ext_t actg
1715: WHERE actg.detail_tax_line_id = itf.detail_tax_line_id
1716: AND actg.accounting_date between p_trl_global_variables_rec.gl_date_low
1717: AND p_trl_global_variables_rec.gl_date_high)*/
1718:

Line 1719: DELETE from zx_rep_actg_ext_t actg

1715: WHERE actg.detail_tax_line_id = itf.detail_tax_line_id
1716: AND actg.accounting_date between p_trl_global_variables_rec.gl_date_low
1717: AND p_trl_global_variables_rec.gl_date_high)*/
1718:
1719: DELETE from zx_rep_actg_ext_t actg
1720: WHERE actg.request_id = p_request_id
1721: AND NOT EXISTS ( SELECT 1 FROM zx_rep_trx_detail_t itf
1722: WHERE actg.detail_tax_line_id = itf.detail_tax_line_id);
1723: