DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on FV_ECON_BENF_DISC

Line 904: where fv_econ_benf_disc.ebd_check(p_payment_process_request_name, l_invoice_id,

900: 5,
901: sysdate,
902: l_org_id
903: from dual
904: where fv_econ_benf_disc.ebd_check(p_payment_process_request_name, l_invoice_id,
905: p_check_date, l_due_date, l_discount_amount_available, l_discount_date) = 'N';
906:
907:
908: end loop;

Line 2105: AND fv_econ_benf_disc.ebd_check(p_checkrun_name, inv.invoice_id,

2101: AND NVL(hzps.party_site_id,-99) = NVL(decode(inv.invoice_type_lookup_code, 'PAYMENT REQUEST', INV.party_site_id, -99), NVL(hzps.party_site_id,-99))
2102: -- Bug 7167192
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

Line 2399: AND fv_econ_benf_disc.ebd_check(p_checkrun_name, inv.invoice_id,

2395: AND NVL(hzps.party_site_id,-99) = NVL(decode(inv.invoice_type_lookup_code, 'PAYMENT REQUEST', INV.party_site_id, -99), hzps.party_site_id)
2396: -- Bug 7167192
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