APPS.DPP_ITEMCOST_PVT dependencies on PER_ORGANIZATION_LIST

Line 346: FROM per_organization_list per,

342: OR (psp.view_all_organizations_flag = 'Y'
343: AND psp.business_group_id IS NULL)
344: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
345: AND EXISTS (SELECT 1
346: FROM per_organization_list per,
347: hr_operating_units hr
348: WHERE per.security_profile_id = psp.security_profile_id
349: AND hr.organization_id = per.organization_id
350: AND hr.usable_flag IS NULL

Line 431: FROM per_organization_list per,

427: OR (psp.view_all_organizations_flag = 'Y'
428: AND psp.business_group_id IS NULL)
429: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
430: AND EXISTS (SELECT 1
431: FROM per_organization_list per,
432: hr_operating_units hr
433: WHERE per.security_profile_id = psp.security_profile_id
434: AND hr.organization_id = per.organization_id
435: AND hr.usable_flag IS NULL

Line 517: FROM per_organization_list per,

513: OR (psp.view_all_organizations_flag = 'Y'
514: AND psp.business_group_id IS NULL)
515: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
516: AND EXISTS (SELECT 1
517: FROM per_organization_list per,
518: hr_operating_units hr
519: WHERE per.security_profile_id = psp.security_profile_id
520: AND hr.organization_id = per.organization_id
521: AND hr.usable_flag IS NULL

Line 604: FROM per_organization_list per,

600: OR (psp.view_all_organizations_flag = 'Y'
601: AND psp.business_group_id IS NULL)
602: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
603: AND EXISTS (SELECT 1
604: FROM per_organization_list per,
605: hr_operating_units hr
606: WHERE per.security_profile_id = psp.security_profile_id
607: AND hr.organization_id = per.organization_id
608: AND hr.usable_flag IS NULL