APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 206: FROM ap_self_assessed_tax_dist_all

202: AND posted_flag = 'N'
203: AND transaction_type = 'PREPAYMENT APPLICATION ADJ'
204: UNION
205: SELECT 'An N is also in the valid flags'
206: FROM ap_self_assessed_tax_dist_all
207: WHERE invoice_id = l_invoice_id
208: AND ((cash_posted_flag = 'N'
209: AND l_cash_basis_flag = 'Y')
210: OR

Line 217: FROM ap_self_assessed_tax_dist_all

213: )
214: -- bug fix 6975868 begin
215: UNION
216: SELECT cash_posted_flag
217: FROM ap_self_assessed_tax_dist_all
218: WHERE invoice_id = l_invoice_id
219: AND l_cash_basis_flag = 'Y'
220: UNION
221: SELECT accrual_posted_flag

Line 222: FROM ap_self_assessed_tax_dist_all

218: WHERE invoice_id = l_invoice_id
219: AND l_cash_basis_flag = 'Y'
220: UNION
221: SELECT accrual_posted_flag
222: FROM ap_self_assessed_tax_dist_all
223: WHERE invoice_id = l_invoice_id
224: AND l_cash_basis_flag <>'Y'
225: UNION
226: SELECT 'P'

Line 227: FROM ap_self_assessed_tax_dist_all

223: WHERE invoice_id = l_invoice_id
224: AND l_cash_basis_flag <>'Y'
225: UNION
226: SELECT 'P'
227: FROM ap_self_assessed_tax_dist_all
228: WHERE invoice_id = l_invoice_id
229: AND ((cash_posted_flag = 'Y'
230: AND l_cash_basis_flag = 'Y')
231: OR

Line 236: FROM ap_self_assessed_tax_dist_all

232: (accrual_posted_flag = 'Y'
233: AND l_cash_basis_flag <> 'Y'))
234: AND EXISTS
235: (SELECT 'An N is also in the valid flags'
236: FROM ap_self_assessed_tax_dist_all
237: WHERE invoice_id = l_invoice_id
238: AND ((cash_posted_flag = 'N'
239: AND l_cash_basis_flag = 'Y')
240: OR

Line 287: FROM ap_self_assessed_tax_dist_all

283: AND posted_flag = 'N'
284: AND transaction_type = 'PREPAYMENT APPLICATION ADJ'
285: UNION
286: SELECT 'An N is also in the valid flags'
287: FROM ap_self_assessed_tax_dist_all
288: WHERE invoice_id = l_invoice_id
289: AND ((cash_posted_flag = 'N'
290: AND l_cash_basis_flag = 'Y')
291: OR

Line 601: FROM ap_self_Assessed_tax_dist_All

597: WHERE invoice_id = l_invoice_id
598: AND nvl(match_status_flag, 'Z') = l_status
599: UNION
600: SELECT count(*) l_count
601: FROM ap_self_Assessed_tax_dist_All
602: WHERE invoice_id = l_invoice_id
603: AND nvl(match_status_flag, 'Z') = l_status
604: );
605: /* Bug 13608357 end */

Line 678: FROM ap_self_assessed_tax_dist_all aid

674: AND rownum < 2;
675:
676: SELECT count(*) --Bug8223290
677: INTO self_match_flag_cnt
678: FROM ap_self_assessed_tax_dist_all aid
679: WHERE aid.invoice_id = l_invoice_id
680: --AND aid.match_status_flag IS NOT NULL
681: AND rownum < 2;
682: