APPS.PSP_POA_BUS dependencies on HR_ORGANIZATION_UNITS

Line 365: FROM hr_organization_units

361: AND funding_source_code = p_funding_source_code;
362:
363: CURSOR organnization_name_csr IS
364: SELECT name
365: FROM hr_organization_units
366: WHERE business_group_id = p_per_business_group_id
367: AND organization_id = p_organization_id
368: AND trunc(sysdate) between date_from and nvl(date_to,trunc(sysdate));
369: