DBA Data[Home] [Help]

APPS.JE_ITWHYE_AP_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 37: -- 08-JUN-2012 FHOLST Added rep_registration_number, table and join for zx_party_tax_profile Bug 14136822

33: --1.2 23-SEP-2009 SURESH SINGH Updated code for PREPAYMENT Invoices
34: --1.3 12-JAN-2012 JSAJJA Updated code to correct the year start date and year end date in beforereport function. as ber bug#13442170
35: --1.4 29-JAN-2012 KHANSEN added code that missed out (bug 13783211)
36: --1.5 15-MAR-2012 KHANSEN updated PROCEDURE je_withholding modified (bug 13829746)
37: -- 08-JUN-2012 FHOLST Added rep_registration_number, table and join for zx_party_tax_profile Bug 14136822
38: --****************************************************************************************
39: -----****************************************************************************************
40: -----------------------------------------------------BEFORE REPORT LOGIC---------------------------------------------------------------
41: ------****************************************************************************************

Line 291: zx_party_tax_profile zpt --Bug 14136822

287: group by dist1.invoice_id)dist
288: ,ap_invoices_all inv,
289: ap_invoice_payments_all aip,
290: ap_checks_all checks,
291: zx_party_tax_profile zpt --Bug 14136822
292: WHERE inv.legal_entity_id = p_legal_entity_id
293: AND inv.invoice_id = dist.invoice_id
294: AND inv.invoice_id = aip.invoice_id
295: AND ( aip.posted_flag IN ('Y', 'P')