DBA Data[Home] [Help]

APPS.PER_AE_XDO_REPORT dependencies on HR_LOOKUPS

Line 173: FROM hr_lookups

169: IF p_units IS NOT NULL THEN
170: BEGIN
171: SELECT meaning
172: INTO l_units
173: FROM hr_lookups
174: WHERE lookup_type = 'QUALIFYING_UNITS'
175: AND lookup_code = p_units;
176: EXCEPTION
177: WHEN OTHERS THEN

Line 551: FROM hr_lookups

547: IF p_units IS NOT NULL THEN
548: BEGIN
549: SELECT meaning
550: INTO l_units
551: FROM hr_lookups
552: WHERE lookup_type = 'QUALIFYING_UNITS'
553: AND lookup_code = p_units;
554: EXCEPTION
555: WHEN OTHERS THEN

Line 974: FROM hr_lookups

970: IF p_units IS NOT NULL THEN
971: BEGIN
972: SELECT meaning
973: INTO l_units
974: FROM hr_lookups
975: WHERE lookup_type = 'QUALIFYING_UNITS'
976: AND lookup_code = p_units;
977: EXCEPTION
978: WHEN OTHERS THEN

Line 1310: from hr_lookups

1306: ,p_lookup_code varchar2)
1307: RETURN VARCHAR2 IS
1308: CURSOR csr_lookup IS
1309: select meaning
1310: from hr_lookups
1311: where lookup_type = p_lookup_type
1312: and lookup_code = p_lookup_code;
1313: l_meaning hr_lookups.meaning%type;
1314: BEGIN

Line 1313: l_meaning hr_lookups.meaning%type;

1309: select meaning
1310: from hr_lookups
1311: where lookup_type = p_lookup_type
1312: and lookup_code = p_lookup_code;
1313: l_meaning hr_lookups.meaning%type;
1314: BEGIN
1315: OPEN csr_lookup;
1316: FETCH csr_lookup INTO l_Meaning;
1317: CLOSE csr_lookup;