DBA Data[Home] [Help]

APPS.PER_US_EEO5_PKG dependencies on HR_ORGANIZATION_UNITS_V

Line 661: hr_organization_units_v hou,

657: SELECT COUNT(1)
658: FROM (
659: SELECT ass.location_id
660: FROM per_all_assignments_f ass,
661: hr_organization_units_v hou,
662: per_all_people_f peo
663: WHERE ass.organization_id = hou.organization_id
664: AND ass.person_id = peo.person_id
665: AND p_report_date between ass.effective_start_date and ass.effective_end_date

Line 678: FROM hr_organization_units_v hou

674:
675:
676: CURSOR csr_schools(p_business_group_id IN NUMBER) IS
677: SELECT COUNT(1)
678: FROM hr_organization_units_v hou
679: WHERE hou.business_group_id = p_business_group_id;
680: l_count_schools NUMBER := 0;
681:
682: CURSOR csr_district_id(p_business_group_id IN NUMBER) IS