DBA Data[Home] [Help]

APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on HR_API

Line 312: held. By going via the HR api, the user should have entered which currencies

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: --

Line 1383: l_date_registered:=hr_api.g_sot;

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