APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on ZX_LINES_DET_FACTORS

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