DBA Data[Home] [Help]

APPS.PER_CEL_BUS dependencies on HR_ORGANIZATION_UNITS

Line 1223: from hr_organization_units

1219: -- cursor to check that the organization_id is valid
1220: --
1221: cursor csr_valid_organization_id is
1222: select business_group_id,date_from,date_to
1223: from hr_organization_units
1224: where organization_id = p_organization_id;
1225: -- and p_effective_date_from >= date_from
1226: -- and nvl(p_effective_date_to,hr_api.g_eot)<=
1227: -- nvl(date_to,hr_api.g_eot);