APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 200: FROM ap_prepay_history_all

196: (accrual_posted_flag = 'N'
197: AND l_cash_basis_flag <> 'Y')) -- bug fix 6975868
198: UNION /*Added for bug 10039729*/
199: SELECT 'An N is also in the valid flags'
200: FROM ap_prepay_history_all
201: WHERE invoice_id = l_invoice_id
202: AND posted_flag = 'N'
203: AND transaction_type = 'PREPAYMENT APPLICATION ADJ'
204: UNION

Line 254: FROM ap_prepay_history_all

250: (accrual_posted_flag = 'N'
251: AND l_cash_basis_flag <> 'Y'))
252: UNION
253: SELECT 'An N is also in the valid flags'
254: FROM ap_prepay_history_all
255: WHERE invoice_id = l_invoice_id
256: AND posted_flag = 'N'
257: AND transaction_type = 'PREPAYMENT APPLICATION ADJ')
258: UNION

Line 261: FROM ap_prepay_history_all

257: AND transaction_type = 'PREPAYMENT APPLICATION ADJ')
258: UNION
259: -- bug9440144
260: SELECT posted_flag
261: FROM ap_prepay_history_all
262: WHERE invoice_id = l_invoice_id
263: AND transaction_type = 'PREPAYMENT APPLICATION ADJ'
264: UNION /*Added for bug 10039729*/
265: SELECT 'P'

Line 266: FROM ap_prepay_history_all

262: WHERE invoice_id = l_invoice_id
263: AND transaction_type = 'PREPAYMENT APPLICATION ADJ'
264: UNION /*Added for bug 10039729*/
265: SELECT 'P'
266: FROM ap_prepay_history_all
267: WHERE invoice_id = l_invoice_id
268: AND transaction_type = 'PREPAYMENT APPLICATION ADJ'
269: AND posted_flag = 'Y'
270: AND EXISTS

Line 281: FROM ap_prepay_history_all

277: (accrual_posted_flag = 'N'
278: AND l_cash_basis_flag <> 'Y'))
279: UNION
280: SELECT 'An N is also in the valid flags'
281: FROM ap_prepay_history_all
282: WHERE invoice_id = l_invoice_id
283: AND posted_flag = 'N'
284: AND transaction_type = 'PREPAYMENT APPLICATION ADJ'
285: UNION