DBA Data[Home] [Help]

APPS.AP_UPDATE_1099_AWT_DISTS_PKG dependencies on AP_INVOICE_PAYMENTS

Line 137: FROM AP_Invoice_Payments IP

133: AND PVS.tax_reporting_site_flag = 'Y'
134: AND NVL(ID.type_1099, 'DUMMY') <> 'MISC4'
135: AND ID.line_type_lookup_code = 'AWT'
136: AND (ID.invoice_id IN (SELECT IP.invoice_id
137: FROM AP_Invoice_Payments IP
138: WHERE ID.invoice_id = IP.invoice_id
139: AND nvl(IP.accounting_date,sysdate)
140: BETWEEN l_start_date AND sysdate
141: )

Line 186: FROM AP_Invoice_Payments IP

182: AND PV.federal_reportable_flag = 'Y'
183: AND PVS.tax_reporting_site_flag = 'Y'
184: )
185: AND (ID.invoice_id IN (SELECT IP.invoice_id
186: FROM AP_Invoice_Payments IP
187: WHERE ID.invoice_id = IP.invoice_id
188: AND nvl(IP.accounting_date,sysdate)
189: BETWEEN l_start_date AND sysdate
190: )