APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on ZX_LINES

Line 415: zx_lines ZX

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

Line 431: FROM zx_lines

427:
428: l_is_upgrade_customer NUMBER := 0;
429: CURSOR c_is_upgrade_customer IS
430: SELECT 1
431: FROM zx_lines
432: WHERE record_type_code= 'MIGRATED'
433: AND rownum=1;
434:
435: l_last_rep_period_start_date DATE;

Line 3450: from zx_lines

3446: p.jg_info_n6 /* tax_line_id */
3447: FROM jg_zz_vat_trx_gt p
3448: WHERE p.jg_info_n9 is not null /* final_reporting_id */
3449: AND p.jg_info_n6 not in ( select tax_line_id
3450: from zx_lines
3451: where cancel_flag = 'Y'
3452: and trx_id = p.jg_info_n4
3453: and tax_line_id = p.jg_info_n6 );
3454:

Line 3783: ,zx_lines_det_factors zdf

3779: FROM ap_invoices_all inv
3780: ,ap_checks_all checks
3781: ,ap_invoice_payments_all pay
3782: ,po_vendors pv
3783: ,zx_lines_det_factors zdf
3784: WHERE inv.set_of_books_id = DECODE(p_legal_entity_id, NULL, p_ledger_id,
3785: inv.set_of_books_id)
3786: AND inv.legal_entity_id = DECODE(p_ledger_id, NULL, p_legal_entity_id,
3787: inv.legal_entity_id)

Line 3829: zx_lines_det_factors zdf

3825: zdf.entity_code,
3826: zdf.event_class_code
3827: FROM ra_customer_trx_all trx,
3828: ar_receivable_applications_all rpt,
3829: zx_lines_det_factors zdf
3830: WHERE trx.customer_trx_id = rpt.applied_customer_trx_id
3831: AND zdf.application_id = 222
3832: AND zdf.trx_id = trx.customer_trx_id
3833: AND trx.set_of_books_id = DECODE(p_legal_entity_id, NULL,

Line 3920: UPDATE zx_lines_det_factors

3916: SET tax_invoice_recording_date = c_inv_null_tax_date_rec.cleared_date
3917: WHERE invoice_id = c_inv_null_tax_date_rec.invoice_id
3918: AND set_of_books_id = c_inv_null_tax_date_rec.set_of_books_id;
3919:
3920: UPDATE zx_lines_det_factors
3921: SET tax_invoice_date = c_inv_null_tax_date_rec.cleared_date
3922: WHERE application_id = 200
3923: AND trx_id = c_inv_null_tax_date_rec.invoice_id
3924: AND entity_code = 'AP_INVOICES'

Line 4005: UPDATE zx_lines_det_factors

4001: -- If accounting method is 'Cash' then
4002: -- update Tax Date to the payment clearing date
4003: -- Update the zx_lies_det_factors table
4004: BEGIN
4005: UPDATE zx_lines_det_factors
4006: SET tax_invoice_date = c_cust_trx_rec.apply_date
4007: WHERE application_id = 222
4008: AND trx_id = c_cust_trx_rec.customer_trx_id
4009: AND entity_code = c_cust_trx_rec.entity_code