DBA Data[Home] [Help]

APPS.DPP_MIG_ADJ_PARA_APPROVAL_PVT dependencies on HR_OPERATING_UNITS

Line 182: from ap_suppliers aps, ap_supplier_sites_all apss, hr_operating_units hr

178: CURSOR supplier_details_cur(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)
179: IS
180: select aps.vendor_id, aps.vendor_name, apss.vendor_site_id, apss.vendor_site_code,
181: apss.org_id, hr.name
182: from ap_suppliers aps, ap_supplier_sites_all apss, hr_operating_units hr
183: where aps.vendor_id = p_vendor_id
184: and aps.vendor_id = apss.vendor_id
185: and apss.vendor_site_id = p_vendor_site_id
186: and apss.org_id = p_org_id

Line 339: from hr_operating_units hr

335: --Cursor to fetch the operating unit name
336: CURSOR operating_unit_cur(p_org_id IN NUMBER)
337: IS
338: select hr.name
339: from hr_operating_units hr
340: where hr.organization_id = p_org_id;
341:
342: BEGIN
343: IF Fnd_Api.to_boolean(p_init_msg_list) THEN