APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on ZX_LINES

Line 412: zx_lines ZX

408: CURSOR c_is_mgr_trx_exist(pn_vat_rep_entity_id number) IS
409: SELECT JGTRD.trx_id
410: FROM jg_zz_vat_trx_details JGTRD,
411: jg_zz_vat_rep_status JGREPS,
412: zx_lines ZX
413: WHERE JGREPS.vat_reporting_entity_id = pn_vat_rep_entity_id
414: AND JGREPS.reporting_status_id = JGTRD.reporting_status_id
415: AND JGREPS.source = JGTRD.extract_source_ledger
416: AND ZX.trx_id = JGTRD.trx_id

Line 3269: from zx_lines

3265: p.jg_info_n6 /* tax_line_id */
3266: FROM jg_zz_vat_trx_gt p
3267: WHERE p.jg_info_n9 is not null /* final_reporting_id */
3268: AND p.jg_info_n6 not in ( select tax_line_id
3269: from zx_lines
3270: where cancel_flag = 'Y'
3271: and trx_id = p.jg_info_n4
3272: and tax_line_id = p.jg_info_n6 );
3273:

Line 3602: ,zx_lines_det_factors zdf

3598: FROM ap_invoices_all inv
3599: ,ap_checks_all checks
3600: ,ap_invoice_payments_all pay
3601: ,po_vendors pv
3602: ,zx_lines_det_factors zdf
3603: WHERE inv.set_of_books_id = DECODE(p_legal_entity_id, NULL, p_ledger_id,
3604: inv.set_of_books_id)
3605: AND inv.legal_entity_id = DECODE(p_ledger_id, NULL, p_legal_entity_id,
3606: inv.legal_entity_id)

Line 3642: zx_lines_det_factors zdf

3638: zdf.entity_code,
3639: zdf.event_class_code
3640: FROM ra_customer_trx_all trx,
3641: ar_receivable_applications_all rpt,
3642: zx_lines_det_factors zdf
3643: WHERE trx.customer_trx_id = rpt.applied_customer_trx_id
3644: AND zdf.application_id = 222
3645: AND zdf.trx_id = trx.customer_trx_id
3646: AND trx.set_of_books_id = DECODE(p_legal_entity_id, NULL,

Line 3733: UPDATE zx_lines_det_factors

3729: SET tax_invoice_recording_date = c_inv_null_tax_date_rec.cleared_date
3730: WHERE invoice_id = c_inv_null_tax_date_rec.invoice_id
3731: AND set_of_books_id = c_inv_null_tax_date_rec.set_of_books_id;
3732:
3733: UPDATE zx_lines_det_factors
3734: SET tax_invoice_date = c_inv_null_tax_date_rec.cleared_date
3735: WHERE application_id = 200
3736: AND trx_id = c_inv_null_tax_date_rec.invoice_id
3737: AND entity_code = 'AP_INVOICES'

Line 3809: UPDATE zx_lines_det_factors

3805: END IF;
3806:
3807: -- Update the zx_lies_det_factors table
3808: BEGIN
3809: UPDATE zx_lines_det_factors
3810: SET tax_invoice_date = c_cust_trx_rec.apply_date
3811: WHERE application_id = 222
3812: AND trx_id = c_cust_trx_rec.customer_trx_id
3813: AND entity_code = c_cust_trx_rec.entity_code