APPS.HR_MEE_VIEWS_GEN dependencies on HR_ALL_ORGANIZATION_UNITS

Line 40: hr_all_organization_units horg,

36: SELECT
37: pcak.concatenated_segments
38: FROM
39: per_all_assignments_f assg,
40: hr_all_organization_units horg,
41: pay_cost_allocation_keyflex pcak
42: WHERE assg.assignment_id = p_assignment_id
43: AND assg.organization_id = horg.organization_id
44: AND assg.Primary_flag = 'Y'

Line 349: l_training_center hr_all_organization_units.name%TYPE;

345:
346: FUNCTION get_training_center (p_training_center_id in number)
347: return varchar2
348: IS
349: l_training_center hr_all_organization_units.name%TYPE;
350:
351: CURSOR c_get_training_center
352: IS
353: SELECT org.name

Line 354: FROM hr_all_organization_units org, hr_organization_information ori

350:
351: CURSOR c_get_training_center
352: IS
353: SELECT org.name
354: FROM hr_all_organization_units org, hr_organization_information ori
355: WHERE org.organization_id = p_training_center_id
356: AND org.organization_id = ori.organization_id
357: AND ori.org_information_context = 'CLASS'
358: AND ori.org_information1 ='OTA_TC';