DBA Data[Home] [Help]

APPS.IGI_CIS2007_UTIL_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 93: l_create_awt_dists_type ap_system_parameters_all.CREATE_AWT_DISTS_TYPE%TYPE;

89: l_awt_group_id_po ap_suppliers.awt_group_id%TYPE;
90: l_pay_awt_group_id_po ap_suppliers.pay_awt_group_id%TYPE;
91: l_awt_group_id_pvs ap_supplier_sites_all.awt_group_id%TYPE;
92: l_pay_awt_group_id_pvs ap_supplier_sites_all.pay_awt_group_id%TYPE;
93: l_create_awt_dists_type ap_system_parameters_all.CREATE_AWT_DISTS_TYPE%TYPE;
94:
95: BEGIN
96:
97: IF (l_vendor_id IS NOT NULL) AND (l_vendor_site_id IS NOT NULL) THEN /* FOR VENDOR SITE */

Line 111: from ap_system_parameters_all

107: upper(allow_awt_flag) = 'Y';
108:
109: select CREATE_AWT_DISTS_TYPE
110: into l_create_awt_dists_type
111: from ap_system_parameters_all
112: where
113: org_id = l_org_id and
114: upper(allow_awt_flag) = 'Y';
115: