DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on AP_INVOICES_PKG

Line 2107: AND AP_INVOICES_PKG.get_wfapproval_status(inv.invoice_id, inv.org_id) in

2103: AND nvl(hzps.location_id,-99) = hzl.location_id (+) -- Bug 5620285
2104: --End of 5929034
2105: AND fv_econ_benf_disc.ebd_check(p_checkrun_name, inv.invoice_id,
2106: p_check_date, due_date, ps.discount_amount_available, ps.discount_date) = 'Y'
2107: AND AP_INVOICES_PKG.get_wfapproval_status(inv.invoice_id, inv.org_id) in
2108: ('NOT REQUIRED','WFAPPROVED','MANUALLY APPROVED')
2109: AND (p_inv_batch_id IS NULL OR
2110: (p_inv_batch_id IS NOT NULL AND inv.batch_id = p_inv_batch_id))
2111: AND inv.vendor_id = nvl(p_inv_vendor_id,inv.vendor_id)

Line 2401: AND AP_INVOICES_PKG.get_wfapproval_status(inv.invoice_id, inv.org_id) in

2397: AND nvl(hzps.location_id,-99) = hzl.location_id(+) -- Bug 5620285
2398: --End Bug 5929034
2399: AND fv_econ_benf_disc.ebd_check(p_checkrun_name, inv.invoice_id,
2400: p_check_date, due_date, ps.discount_amount_available, ps.discount_date) = 'Y'
2401: AND AP_INVOICES_PKG.get_wfapproval_status(inv.invoice_id, inv.org_id) in
2402: ('NOT REQUIRED','WFAPPROVED','MANUALLY APPROVED')
2403: AND (p_inv_batch_id IS NULL OR
2404: (p_inv_batch_id IS NOT NULL AND inv.batch_id = p_inv_batch_id))
2405: AND inv.vendor_id = nvl(p_inv_vendor_id,inv.vendor_id)