APPS.JG_ZZ_VAT_PRE_REP_PROC_PKG dependencies on ZX_LINES

Line 108: zx_lines ZX

104: IS
105: SELECT JGTRD.trx_id
106: FROM jg_zz_vat_trx_details JGTRD,
107: jg_zz_vat_rep_status JGREPS,
108: zx_lines ZX
109: WHERE JGREPS.vat_reporting_entity_id = pn_vat_rep_entity_id
110: AND JGREPS.reporting_status_id = JGTRD.reporting_status_id
111: AND JGREPS.source = JGTRD.extract_source_ledger
112: AND ZX.trx_id = JGTRD.trx_id

Line 142: FROM zx_lines

138: l_is_upgrade_customer NUMBER := 0;
139:
140: CURSOR c_is_upgrade_customer IS
141: SELECT 1
142: FROM zx_lines
143: WHERE record_type_code= 'MIGRATED'
144: AND rownum=1;
145:
146: BEGIN

Line 272: 'UPDATE zx_lines zxl

268:
269: << continue_loop >>
270:
271: l_update_query_ap :=
272: 'UPDATE zx_lines zxl
273: SET zxl.legal_reporting_status =''000000000000000''
274: ,LAST_UPDATED_BY = -5
275: ,LAST_UPDATE_DATE = sysdate
276: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1

Line 395: FROM zx_lines_det_factors zxd

391: l_update_query_ap := l_update_query_ap ||
392: ' AND zxl.application_id = 200
393: AND zxl.trx_id IN
394: (SELECT zxd.trx_id
395: FROM zx_lines_det_factors zxd
396: WHERE zxd.tax_invoice_date > $l_end_date$
397: AND zxd.application_id = zxl.application_id
398: AND zxd.EVENT_CLASS_CODE = zxl.EVENT_CLASS_CODE
399: AND zxd.ENTITY_CODE = zxl.entity_code

Line 408: FROM zx_lines_det_factors zxd

404: l_update_query_ar := l_update_query_ar ||
405: ' AND zxl.application_id = 222
406: AND zxl.trx_id IN
407: (SELECT zxd.trx_id
408: FROM zx_lines_det_factors zxd
409: WHERE zxd.tax_invoice_date > $l_end_date$
410: AND zxd.application_id = zxl.application_id
411: AND zxd.EVENT_CLASS_CODE = zxl.EVENT_CLASS_CODE
412: AND zxd.ENTITY_CODE = zxl.entity_code