APPS.FV_FACTS_GL_PKG_EXT dependencies on PO_VENDORS

Line 156: --* : po_vendors SELECT *--

152: --* Calls : fv_utility.debug_mesg *--
153: --* : fv_utility.log_mesg *--
154: --* : get_fed_system_parameters *--
155: --* Tables Used : gl_period_statuses SELECT *--
156: --* : po_vendors SELECT *--
157: --* : ra_customers SELECT *--
158: --* : fnd_concurrent_programs SELECT *--
159: --* Logic : *--
160: --****************************************************************************************--

Line 357: 'FROM po_vendors

353: IF (p_retcode = g_SUCCESS) THEN
354: IF (p_vendor_or_cust = 'V') THEN
355: l_select_stmt := 'SELECT vendor_type_lookup_code vendor_type, '||
356: l_vendor_attribute||' elimnation_id '||
357: 'FROM po_vendors
358: WHERE vendor_id = :p_vendor_or_cust_id';
359: ELSE
360: l_select_stmt := 'SELECT customer_class_code vendor_type, '||
361: l_customer_attribute||' elimnation_id '||

Line 491: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;

487: IS
488: l_module_name VARCHAR2(200);
489: l_location VARCHAR2(200);
490:
491: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
492: l_elimination_id po_vendors.attribute1%TYPE;
493: l_from_period_num gl_period_statuses.period_num%TYPE;
494: l_to_period_num gl_period_statuses.period_num%TYPE;
495: l_period_year gl_period_statuses.period_year%TYPE;

Line 492: l_elimination_id po_vendors.attribute1%TYPE;

488: l_module_name VARCHAR2(200);
489: l_location VARCHAR2(200);
490:
491: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
492: l_elimination_id po_vendors.attribute1%TYPE;
493: l_from_period_num gl_period_statuses.period_num%TYPE;
494: l_to_period_num gl_period_statuses.period_num%TYPE;
495: l_period_year gl_period_statuses.period_year%TYPE;
496: l_rows NUMBER := 0;