DBA Data[Home] [Help]

APPS.HR_SUIT_MATCH_UTIL_SS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1115: FROM hr_all_organization_units_tl

1111: RETURN VARCHAR2
1112: IS
1113: CURSOR csr_bg_name IS
1114: SELECT name
1115: FROM hr_all_organization_units_tl
1116: WHERE organization_id = p_bg_id
1117: AND language = userenv('LANG');
1118:
1119: l_bg_name hr_all_organization_units_tl.name%type;

Line 1119: l_bg_name hr_all_organization_units_tl.name%type;

1115: FROM hr_all_organization_units_tl
1116: WHERE organization_id = p_bg_id
1117: AND language = userenv('LANG');
1118:
1119: l_bg_name hr_all_organization_units_tl.name%type;
1120:
1121: BEGIN
1122:
1123: OPEN csr_bg_name;