APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 533: from hr_all_organization_units hou

529: start with pose.organization_id_parent = g_organization_id
530: connect by prior pose.organization_id_child = pose.organization_id_parent
531: union
532: select hou.organization_id
533: from hr_all_organization_units hou
534: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
535: and hou.organization_id <> hou.business_group_id
536: union
537: select g_organization_id

Line 601: from hr_all_organization_units hou

597: start with pose.organization_id_parent = g_organization_id
598: connect by prior pose.organization_id_child = pose.organization_id_parent
599: union
600: select hou.organization_id
601: from hr_all_organization_units hou
602: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
603: and hou.organization_id <> hou.business_group_id
604: union
605: select g_organization_id

Line 673: from hr_all_organization_units hou

669: start with pose.organization_id_parent = g_organization_id
670: connect by prior pose.organization_id_child = pose.organization_id_parent
671: union
672: select hou.organization_id
673: from hr_all_organization_units hou
674: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
675: and hou.organization_id <> hou.business_group_id
676: union
677: select g_organization_id

Line 745: from hr_all_organization_units hou

741: start with pose.organization_id_parent = g_organization_id
742: connect by prior pose.organization_id_child = pose.organization_id_parent
743: union
744: select hou.organization_id
745: from hr_all_organization_units hou
746: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
747: and hou.organization_id <> hou.business_group_id
748: union
749: select g_organization_id