APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on ZX_LINES_DET_FACTORS

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