DBA Data[Home] [Help]

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;