DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on FV_ECON_BENF_DISC

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

1291: 5,
1292: sysdate,
1293: l_org_id
1294: from dual
1295: where fv_econ_benf_disc.ebd_check(p_payment_process_request_name, l_invoice_id,
1296: p_check_date, l_due_date, l_discount_amount_available, l_discount_date) = 'N';
1297:
1298:
1299: end loop;

Line 3029: ' AND fv_econ_benf_disc.ebd_check(:p_checkrun_name, ai.invoice_id, '||

3025: ' AND NVL(hzps.party_site_id,-99) = NVL(decode(ai.invoice_type_lookup_code, ''PAYMENT REQUEST'', ai.party_site_id, -99), NVL(hzps.party_site_id,-99)) '||
3026: -- Bug 7167192
3027: ' AND nvl(hzps.location_id,-99) = hzl.location_id (+) '||-- Bug 5620285
3028: --End of 5929034
3029: ' AND fv_econ_benf_disc.ebd_check(:p_checkrun_name, ai.invoice_id, '||
3030: ' to_date(:p_check_date, ''DD-MM-YYYY''), due_date, ps.discount_amount_available, ps.discount_date) = ''Y'' ';
3031:
3032: -- Bug 7265013 starts
3033: -- AND AP_INVOICES_PKG.get_wfapproval_status(inv.invoice_id, inv.org_id) in

Line 3852: ' AND fv_econ_benf_disc.ebd_check(:p_checkrun_name, ai.invoice_id, '||

3848: ' AND NVL(hzps.party_site_id,-99) = NVL(decode(ai.invoice_type_lookup_code, ''PAYMENT REQUEST'', ai.party_site_id, -99), hzps.party_site_id) '||
3849: -- Bug 7167192
3850: ' AND nvl(hzps.location_id,-99) = hzl.location_id(+) '|| -- Bug 5620285
3851: --End Bug 5929034
3852: ' AND fv_econ_benf_disc.ebd_check(:p_checkrun_name, ai.invoice_id, '||
3853: ' to_date(:p_check_date, ''DD-MM-YYYY''), due_date, ps.discount_amount_available, ps.discount_date) = ''Y'' ';
3854: -- Bug 7265013 starts
3855: -- AND AP_INVOICES_PKG.get_wfapproval_status(inv.invoice_id, inv.org_id) in
3856: -- ('NOT REQUIRED','WFAPPROVED','MANUALLY APPROVED')