APPS.PER_INC_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 30: ,hr_organization_information hoi

26: cursor csr_sec_grp is
27: select null
28: from per_work_incidents inc
29: ,per_people_f per
30: ,hr_organization_information hoi
31: where inc.incident_id = p_incident_id
32: and per.person_id = inc.person_id
33: and hoi.organization_id = per.business_group_id
34: and hoi.org_information_context||'' = 'Business Group Information';

Line 2132: from hr_organization_information hoi

2128: and hou.business_group_id = p_business_group_id
2129: and nvl(p_notified_rep_date, hou.date_from) between hou.date_from
2130: and nvl(hou.date_to,hr_general.end_of_time)
2131: and p_notified_rep_org_id in (select hoi.organization_id
2132: from hr_organization_information hoi
2133: where hoi.org_information_context = 'CLASS'
2134: and hoi.org_information1 = 'REPBODY'
2135: and hoi.org_information2 = 'Y');
2136: --

Line 3131: ,hr_organization_information org

3127: --
3128: cursor csr_us_bg is
3129: select business_group_id
3130: from hr_all_organization_units units
3131: ,hr_organization_information org
3132: where units.organization_id = org.organization_id
3133: --and units.type = 'BG'
3134: and mod(business_group_id,p_number_of_workers) = p_current_worker-1
3135: and org.org_information_context = 'Business Group Information'