DBA Data[Home] [Help]

APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on HR_API

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

307: Possible ways of speeding it up are :
308: - Add a cache
309: - Hit the GL tables directly.
310: The issue with point2 is that that there is no guarentee any currency will be
311: held. By going via the HR api, the user should have entered which currencies
312: will be held for which business groups.
313: Definitely isn't ideal and needs performance testing.
314: */
315: --

Line 1564: l_date_registered := hr_api.g_sot;

1560: --
1561: if (p_candidacy_age>0) then
1562: l_date_registered:=trunc(sysdate)-p_candidacy_age;
1563: else
1564: l_date_registered := hr_api.g_sot;
1565: end if;
1566: --
1567: -- **************************************************************************
1568: -- Inner SQL to find Job Seekers for open vacancies