APPS.DPP_ITEMCOST_PVT dependencies on PER_ORGANIZATION_LIST

Line 348: FROM per_organization_list per,

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

Line 433: FROM per_organization_list per,

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

Line 519: FROM per_organization_list per,

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

Line 606: FROM per_organization_list per,

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