APPS.DPP_PURCHASEPRICE_PVT dependencies on HR_OPERATING_UNITS

Line 213: FROM hr_operating_units hr

209: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)
210: AND ((psp.view_all_organizations_flag = 'Y'
211: AND psp.business_group_id IS NOT NULL
212: AND EXISTS (SELECT 1
213: FROM hr_operating_units hr
214: WHERE hr.business_group_id = psp.business_group_id
215: AND hr.usable_flag IS NULL
216: AND hr.organization_id =
217: l_item_price_rec.org_id))

Line 223: hr_operating_units hr

219: AND psp.business_group_id IS NULL)
220: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
221: AND EXISTS (SELECT 1
222: FROM per_organization_list per,
223: hr_operating_units hr
224: WHERE per.security_profile_id = psp.security_profile_id
225: AND hr.organization_id = per.organization_id
226: AND hr.usable_flag IS NULL
227: AND per.organization_id = l_item_price_rec.org_id)))

Line 298: FROM hr_operating_units hr

294: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)
295: AND ((psp.view_all_organizations_flag = 'Y'
296: AND psp.business_group_id IS NOT NULL
297: AND EXISTS (SELECT 1
298: FROM hr_operating_units hr
299: WHERE hr.business_group_id = psp.business_group_id
300: AND hr.usable_flag IS NULL
301: AND hr.organization_id = l_item_price_rec.org_id))
302: OR (psp.view_all_organizations_flag = 'Y'

Line 307: hr_operating_units hr

303: AND psp.business_group_id IS NULL)
304: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
305: AND EXISTS (SELECT 1
306: FROM per_organization_list per,
307: hr_operating_units hr
308: WHERE per.security_profile_id = psp.security_profile_id
309: AND hr.organization_id = per.organization_id
310: AND hr.usable_flag IS NULL
311: AND per.organization_id = l_item_price_rec.org_id)))

Line 383: FROM hr_operating_units hr

379: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)
380: AND ((psp.view_all_organizations_flag = 'Y'
381: AND psp.business_group_id IS NOT NULL
382: AND EXISTS (SELECT 1
383: FROM hr_operating_units hr
384: WHERE hr.business_group_id = psp.business_group_id
385: AND hr.usable_flag IS NULL
386: AND hr.organization_id = l_item_price_rec.org_id))
387: OR (psp.view_all_organizations_flag = 'Y'

Line 392: hr_operating_units hr

388: AND psp.business_group_id IS NULL)
389: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
390: AND EXISTS (SELECT 1
391: FROM per_organization_list per,
392: hr_operating_units hr
393: WHERE per.security_profile_id = psp.security_profile_id
394: AND hr.organization_id = per.organization_id
395: AND hr.usable_flag IS NULL
396: AND per.organization_id = l_item_price_rec.org_id)))

Line 468: FROM hr_operating_units hr

464: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)
465: AND ((psp.view_all_organizations_flag = 'Y'
466: AND psp.business_group_id IS NOT NULL
467: AND EXISTS (SELECT 1
468: FROM hr_operating_units hr
469: WHERE hr.business_group_id = psp.business_group_id
470: AND hr.usable_flag IS NULL
471: AND hr.organization_id = l_item_price_rec.org_id))
472: OR (psp.view_all_organizations_flag = 'Y'

Line 477: hr_operating_units hr

473: AND psp.business_group_id IS NULL)
474: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
475: AND EXISTS (SELECT 1
476: FROM per_organization_list per,
477: hr_operating_units hr
478: WHERE per.security_profile_id = psp.security_profile_id
479: AND hr.organization_id = per.organization_id
480: AND hr.usable_flag IS NULL
481: AND per.organization_id = l_item_price_rec.org_id)))

Line 1082: FROM hr_operating_units

1078: l_po_notify_hdr_rec.Vendor_Site_Code := l_vendor_site_rec.Vendor_Site_Code;
1079:
1080: SELECT name
1081: INTO l_operating_unit_name
1082: FROM hr_operating_units
1083: WHERE organization_id = l_po_notify_hdr_rec.org_id;
1084:
1085: l_po_notify_hdr_rec.Operating_Unit := l_operating_unit_name;
1086: p_po_notify_hdr_rec := l_po_notify_hdr_rec;