DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPSUPR_PKG dependencies on AP_SUPPLIERS

Line 190: FROM ap_suppliers

186: BEGIN
187:
188: SELECT 'VERIFIED'
189: INTO verify_status
190: FROM ap_suppliers
191: WHERE vendor_id = l_vendor_id
192: AND cis_verification_date > add_months(sysdate,-24)
193: AND rownum = 1;
194:

Line 255: FROM ap_suppliers

251: BEGIN
252:
253: SELECT 'VERIFIED'
254: INTO verify_status
255: FROM ap_suppliers
256: WHERE vendor_id = l_vendor_id
257: AND cis_verification_date > add_months(sysdate,-24)
258: AND rownum = 1;
259: