DBA Data[Home] [Help]

APPS.PA_RESOURCES_PKG dependencies on PO_VENDORS

Line 180: P_vendor_name po_vendors.vendor_name%TYPE;

176: P_employee_name VARCHAR2(60);
177:
178: /* Bug Fix Code for Bug#2487415 UTF8. Changing the variable type to %TYPE. Modified the bug fix of
179: 2178043 */
180: P_vendor_name po_vendors.vendor_name%TYPE;
181:
182: P_Name VARCHAR2(80); -- Bug 2191972, incresed the size from 60 to 80.
183: /*Commented the code for bug# 4143659 as this is not required.
184: P_START_DATE_ACTIVE pa_resources.start_date_active%TYPE; */

Line 241: from po_vendors pv --For 1807084, po_vendors replaces pa_vendors_res_v

237: elsif
238: P_Resource_Type_Code = 'VENDOR' then
239: select pv.vendor_name -- Bug#2178043
240: into P_vendor_name
241: from po_vendors pv --For 1807084, po_vendors replaces pa_vendors_res_v
242: ,pa_resource_txn_attributes prta
243: where prta.vendor_id = pv.vendor_id
244: and prta.resource_id = P_resource_id;
245: