APPS.DPP_PURCHASEPRICE_PVT dependencies on PER_ORGANIZATION_LIST

Line 222: FROM per_organization_list per,

218: OR (psp.view_all_organizations_flag = 'Y'
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

Line 306: FROM per_organization_list per,

302: OR (psp.view_all_organizations_flag = 'Y'
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

Line 391: FROM per_organization_list per,

387: OR (psp.view_all_organizations_flag = 'Y'
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

Line 476: FROM per_organization_list per,

472: OR (psp.view_all_organizations_flag = 'Y'
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