APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 197: FROM ap_self_assessed_tax_dist_all

193: AND l_cash_basis_flag <> 'Y'))) -- bug fix 6975868;
194: -- bug fix 6975868 begin
195: UNION
196: SELECT cash_posted_flag
197: FROM ap_self_assessed_tax_dist_all
198: WHERE invoice_id = l_invoice_id
199: AND l_cash_basis_flag = 'Y'
200: UNION
201: SELECT accrual_posted_flag

Line 202: FROM ap_self_assessed_tax_dist_all

198: WHERE invoice_id = l_invoice_id
199: AND l_cash_basis_flag = 'Y'
200: UNION
201: SELECT accrual_posted_flag
202: FROM ap_self_assessed_tax_dist_all
203: WHERE invoice_id = l_invoice_id
204: AND l_cash_basis_flag <>'Y'
205: UNION
206: SELECT 'P'

Line 207: FROM ap_self_assessed_tax_dist_all

203: WHERE invoice_id = l_invoice_id
204: AND l_cash_basis_flag <>'Y'
205: UNION
206: SELECT 'P'
207: FROM ap_self_assessed_tax_dist_all
208: WHERE invoice_id = l_invoice_id
209: AND ((cash_posted_flag = 'Y'
210: AND l_cash_basis_flag = 'Y')
211: OR

Line 216: FROM ap_self_assessed_tax_dist_all

212: (accrual_posted_flag = 'Y'
213: AND l_cash_basis_flag <> 'Y'))
214: AND EXISTS
215: (SELECT 'An N is also in the valid flags'
216: FROM ap_self_assessed_tax_dist_all
217: WHERE invoice_id = l_invoice_id
218: AND ((cash_posted_flag = 'N'
219: AND l_cash_basis_flag = 'Y')
220: OR