APPS.AP_TP_STMT_PKG dependencies on AP_INVOICES_PKG

Line 232: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)

228: AND ai.org_id = p_in_org_id
229: AND ((AP_TP_STMT_PKG.invoice_validate_status(ai.invoice_id) = 'Y' --'Y' Bug9252303
230: AND P_UNVALIDATED_TRX = 'N')
231: OR P_UNVALIDATED_TRX = 'Y')
232: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
233: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'
234: ,'UNACCOUNTED','N'
235: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))
236: AND ((P_UNAPPROVED_TRX = 'N'

Line 235: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))

231: OR P_UNVALIDATED_TRX = 'Y')
232: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
233: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'
234: ,'UNACCOUNTED','N'
235: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))
236: AND ((P_UNAPPROVED_TRX = 'N'
237: AND ai.wfapproval_status IN ('ACCEPT','APPROVED','MANUALLY APPROVED','NOT REQUIRED','WFAPPROVED','ACKNOWLEDGE','CANCEL','CANCELLED'))
238: OR (P_UNAPPROVED_TRX = 'Y' ))
239: UNION ALL

Line 271: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)

267: AND ai.vendor_site_id = p_in_vendor_site_id
268: AND ai.invoice_currency_code = NVL2(P_CURRENCY,DECODE(P_CURRENCY,'ANY',ai.invoice_currency_code,P_CURRENCY),ai.invoice_currency_code)
269: AND ai.org_id = p_in_org_id
270: AND ai.wfapproval_status NOT IN ('CANCEL','CANCELLED')
271: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
272: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'
273: ,'UNACCOUNTED','N'
274: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))
275: AND ((P_UNAPPROVED_TRX = 'N'

Line 274: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))

270: AND ai.wfapproval_status NOT IN ('CANCEL','CANCELLED')
271: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
272: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'
273: ,'UNACCOUNTED','N'
274: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))
275: AND ((P_UNAPPROVED_TRX = 'N'
276: AND ai.wfapproval_status IN ('ACCEPT','APPROVED','MANUALLY APPROVED','NOT REQUIRED','WFAPPROVED','ACKNOWLEDGE'))
277: OR (P_UNAPPROVED_TRX = 'Y' ))*/
278: );