DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on ZX_REP_ACTG_EXT_T

Line 1825: FROM zx_rep_actg_ext_t actg

1821: AND (NVL(itf.reverse_flag,'N') = 'Y'
1822: OR itf.tax_type_code <> NVL(p_trl_global_variables_rec.per_tax_type_code_high,
1823: p_trl_global_variables_rec.per_tax_type_code_low));
1824: /*AND NOT EXISTS ( SELECT 1
1825: FROM zx_rep_actg_ext_t actg
1826: WHERE actg.detail_tax_line_id = itf.detail_tax_line_id
1827: AND actg.accounting_date between p_trl_global_variables_rec.gl_date_low
1828: AND p_trl_global_variables_rec.gl_date_high)*/
1829:

Line 1830: DELETE from zx_rep_actg_ext_t actg

1826: WHERE actg.detail_tax_line_id = itf.detail_tax_line_id
1827: AND actg.accounting_date between p_trl_global_variables_rec.gl_date_low
1828: AND p_trl_global_variables_rec.gl_date_high)*/
1829:
1830: DELETE from zx_rep_actg_ext_t actg
1831: WHERE actg.request_id = p_request_id
1832: AND NOT EXISTS ( SELECT 1 FROM zx_rep_trx_detail_t itf
1833: WHERE actg.detail_tax_line_id = itf.detail_tax_line_id);
1834: