APPS.PER_EVS_MAG_REPORT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 75: FROM hr_all_organization_units hou,

71:
72: CURSOR c_gre(p_business_group_id IN NUMBER) IS
73: SELECT hou.organization_id organization_id,
74: hou.name org_name
75: FROM hr_all_organization_units hou,
76: hr_organization_information hoi
77: WHERE hou.business_group_id = p_business_group_id
78: AND hou.organization_id = hoi.organization_id
79: AND hoi.org_information_context = 'CLASS'

Line 85: FROM hr_all_organization_units hou,

81:
82: CURSOR c_get_requester_code(p_organization_id IN NUMBER) IS
83: SELECT hoi.org_information1 requester_code,
84: hou.name org_name
85: FROM hr_all_organization_units hou,
86: hr_organization_information hoi
87: WHERE hoi.organization_id = hou.organization_id
88: AND hoi.organization_id = p_organization_id
89: AND hoi.org_information_context = 'EVS Filing';

Line 93: FROM hr_all_organization_units hou

89: AND hoi.org_information_context = 'EVS Filing';
90:
91: CURSOR c_gre_name(p_organization_id IN NUMBER) IS
92: SELECT hou.name org_name
93: FROM hr_all_organization_units hou
94: WHERE hou.organization_id = p_organization_id;
95:
96:
97: l_text VARCHAR(2000);

Line 342: hr_all_organization_units hou,

338: hsck.segment1
339: from per_all_people_f ppf ,
340: per_all_assignments_f paf,
341: hr_soft_coding_keyflex hsck,
342: hr_all_organization_units hou,
343: hr_organization_information hoi,
344: per_assignment_status_types past
345: where paf.assignment_type = 'E'
346: and paf.primary_flag = 'Y'