DBA Data[Home] [Help]

APPS.PER_US_EEO5_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 257: FROM hr_organization_information

253: org_information10 contact_telephone,
254: org_information12 control_number,
255: org_information13 system_district,
256: org_information13||' SUMMARY' type_report
257: FROM hr_organization_information
258: WHERE org_information_context = 'EEO_REPORT'
259: AND organization_id = p_business_group_id;
260:
261: --Modified for bug 5437066

Line 736: FROM hr_organization_information

732: l_count_schools NUMBER := 0;
733:
734: CURSOR csr_district_id(p_business_group_id IN NUMBER) IS
735: SELECT org_information12 district_id
736: FROM hr_organization_information
737: WHERE org_information_context = 'EEO_REPORT'
738: AND org_information11 = 'EEO5'
739: AND organization_id = p_business_group_id;
740: