DBA Data[Home] [Help]

APPS.PER_US_EEO5_PKG dependencies on HR_ORGANIZATION_UNITS_V

Line 713: hr_organization_units_v hou,

709: SELECT COUNT(1)
710: FROM (
711: SELECT ass.location_id
712: FROM per_all_assignments_f ass,
713: hr_organization_units_v hou,
714: per_all_people_f peo
715: WHERE ass.organization_id = hou.organization_id
716: AND ass.person_id = peo.person_id
717: AND p_report_date between ass.effective_start_date and ass.effective_end_date

Line 730: FROM hr_organization_units_v hou

726:
727:
728: CURSOR csr_schools(p_business_group_id IN NUMBER) IS
729: SELECT COUNT(1)
730: FROM hr_organization_units_v hou
731: WHERE hou.business_group_id = p_business_group_id;
732: l_count_schools NUMBER := 0;
733:
734: CURSOR csr_district_id(p_business_group_id IN NUMBER) IS