APPS.HR_SUIT_MATCH_UTIL_SS dependencies on HR_ALL_ORGANIZATION_UNITS_TL
Line 1097: FROM hr_all_organization_units_tl
1093: RETURN VARCHAR2
1094: IS
1095: CURSOR csr_bg_name IS
1096: SELECT name 1097: FROM hr_all_organization_units_tl 1098: WHERE organization_id = p_bg_id
1099: AND language = userenv('LANG');
1100:
1101: l_bg_name hr_all_organization_units_tl.name%type;
Line 1101: l_bg_name hr_all_organization_units_tl.name%type;
1097: FROM hr_all_organization_units_tl
1098: WHERE organization_id = p_bg_id
1099: AND language = userenv('LANG');
1100: 1101: l_bg_name hr_all_organization_units_tl.name%type; 1102:
1103: BEGIN
1104:
1105: OPEN csr_bg_name;