DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on AP_INVOICES_ALL

Line 3598: FROM ap_invoices_all inv

3594: inv.tax_invoice_recording_date,
3595: inv.invoice_type_lookup_code,
3596: checks.cleared_date,
3597: pv.small_business_flag
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

Line 3728: UPDATE ap_invoices_all

3724: OR ((c_inv_null_tax_date_rec.invoice_type_lookup_code = 'PREPAYMENT')
3725: OR (c_inv_null_tax_date_rec.small_business_flag = 'Y')) THEN
3726:
3727: IF c_inv_null_tax_date_rec.cleared_date < p_end_date THEN
3728: UPDATE ap_invoices_all
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: