DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPVERP_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 263: l_create_awt_dists_type ap_system_parameters_all.CREATE_AWT_DISTS_TYPE%TYPE;

259:
260: /* Bug#7218825 - CIS WITHHOLDING PROJECT DUE TO AP ENHANCEMENT 6639866 ON 12.1 */
261:
262: l_org_id ap_supplier_sites_all.org_id%TYPE;
263: l_create_awt_dists_type ap_system_parameters_all.CREATE_AWT_DISTS_TYPE%TYPE;
264:
265: Cursor c_povs_orgs(c_vendor_id NUMBER) is
266: select distinct org_id
267: from ap_supplier_sites_all

Line 273: from ap_system_parameters_all

269: and upper(allow_awt_flag) = 'Y';
270:
271: Cursor c_awt_type(c_org_id NUMBER) is
272: select CREATE_AWT_DISTS_TYPE
273: from ap_system_parameters_all
274: where org_id = c_org_id
275: and upper(allow_awt_flag) = 'Y';
276:
277: BEGIN