DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on AP_INVOICES_ALL

Line 3779: FROM ap_invoices_all inv

3775: inv.tax_invoice_recording_date,
3776: inv.invoice_type_lookup_code,
3777: checks.cleared_date,
3778: pv.small_business_flag
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

Line 3915: UPDATE ap_invoices_all

3911: OR ((c_inv_null_tax_date_rec.invoice_type_lookup_code = 'PREPAYMENT')
3912: OR (c_inv_null_tax_date_rec.small_business_flag = 'Y')) THEN
3913:
3914: IF c_inv_null_tax_date_rec.cleared_date < p_end_date THEN
3915: UPDATE ap_invoices_all
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: