APPS.PAY_JP_ITWB_REPORT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1553: from hr_all_organization_units hou

1549: start with pose.organization_id_parent = g_organization_id
1550: connect by prior pose.organization_id_child = pose.organization_id_parent
1551: union
1552: select hou.organization_id
1553: from hr_all_organization_units hou
1554: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
1555: and hou.organization_id <> hou.business_group_id
1556: union
1557: select g_organization_id

Line 1624: from hr_all_organization_units hou

1620: start with pose.organization_id_parent = g_organization_id
1621: connect by prior pose.organization_id_child = pose.organization_id_parent
1622: union
1623: select hou.organization_id
1624: from hr_all_organization_units hou
1625: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
1626: and hou.organization_id <> hou.business_group_id
1627: union
1628: select g_organization_id

Line 2213: from hr_all_organization_units hou

2209: start with pose.organization_id_parent = g_organization_id
2210: connect by prior pose.organization_id_child = pose.organization_id_parent
2211: union
2212: select hou.organization_id
2213: from hr_all_organization_units hou
2214: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
2215: and hou.organization_id <> hou.business_group_id
2216: union
2217: select g_organization_id