308: Possible ways of speeding it up are :
309: - Add a cache
310: - Hit the GL tables directly.
311: The issue with point2 is that that there is no guarentee any currency will be
312: held. By going via the HR api, the user should have entered which currencies
313: will be held for which business groups.
314: Definitely isn't ideal and needs performance testing.
315: */
316: --
1379: --
1380: if (p_candidacy_age>0) then
1381: l_date_registered:=trunc(sysdate)-p_candidacy_age;
1382: else
1383: l_date_registered:=hr_api.g_sot;
1384: end if;
1385: --
1386: -- **************************************************************************
1387: -- Inner SQL to find Job Seekers for open vacancies