APPS.OTA_GENERAL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 865: from hr_all_organization_units orgs,hr_all_organization_units_tl orgs_tl

861: --
862: cursor csr_lookup is
863: --Bug 2846475
864: select orgs_tl.name
865: from hr_all_organization_units orgs,hr_all_organization_units_tl orgs_tl
866: where orgs.organization_id = p_organization_id
867: and orgs.organization_id = orgs_tl.organization_id
868: and orgs_tl.language = userenv('LANG');
869: -- select name

Line 874: v_description hr_all_organization_units.name%TYPE := null;

870: -- from hr_organization_units
871: -- where organization_id = p_organization_id;
872:
873: --
874: v_description hr_all_organization_units.name%TYPE := null;
875: begin
876: if p_organization_id is not null then
877: --
878: open csr_lookup;

Line 1059: l_training_center hr_all_organization_units.name%TYPE;

1055: function get_training_center (p_training_center_id in number)
1056: return varchar2
1057: IS
1058: l_business_group_id number;
1059: l_training_center hr_all_organization_units.name%TYPE;
1060:
1061: CURSOR c_get_training_center
1062: IS
1063: SELECT org.name

Line 1064: FROM hr_all_organization_units org, hr_organization_information ori

1060:
1061: CURSOR c_get_training_center
1062: IS
1063: SELECT org.name
1064: FROM hr_all_organization_units org, hr_organization_information ori
1065: WHERE org.business_group_id = l_business_group_id
1066: AND org.organization_id = p_training_center_id
1067: AND org.organization_id = ori.organization_id
1068: AND ori.org_information_context = 'CLASS'

Line 1180: FROM hr_all_organization_units_tl org

1176: IS
1177: --
1178: CURSOR org_name_cr IS
1179: SELECT org.name
1180: FROM hr_all_organization_units_tl org
1181: WHERE org.organization_id = p_organization_id
1182: AND org.language = USERENV('LANG');
1183:
1184: --

Line 1185: l_org_name hr_all_organization_units.name%TYPE := null;

1181: WHERE org.organization_id = p_organization_id
1182: AND org.language = USERENV('LANG');
1183:
1184: --
1185: l_org_name hr_all_organization_units.name%TYPE := null;
1186: --
1187: begin
1188: --
1189: --