DBA Data[Home] [Help]

APPS.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 416: , hr_organization_units hou

412: and pet.business_group_id is not null
413: union
414: select distinct(hou.business_group_id) bg
415: from hxt_holiday_calendars hcl
416: , hr_organization_units hou
417: where hcl.id = p_hcl_id
418: and hcl.organization_id = hou.organization_id
419: and hou.business_group_id is not null;
420: --

Line 1653: , hr_organization_units hou

1649: union
1650: select distinct
1651: hou.business_group_id bg_id
1652: from hxt_holiday_calendars hcl
1653: , hr_organization_units hou
1654: where hcl.id = p_id
1655: and hcl.organization_id = hou.organization_id
1656: and hou.business_group_id is not null;
1657: --