DBA Data[Home] [Help]

APPS.GHR_SS_VIEWS_PKG dependencies on GHR_SS_VIEWS_PKG

Line 1: PACKAGE BODY ghr_ss_views_pkg AS

1: PACKAGE BODY ghr_ss_views_pkg AS
2: /* $Header: ghssview.pkb 120.4.12010000.4 2008/11/03 08:48:51 managarw ship $ */
3: --
4: -- This is global variable to store flex number for performance SIT .
5: -- This variable is used as cache.

Line 501: select nvl(substr((select ghr_ss_views_pkg.get_people_ei_id_ason_date(p_person_id,p_information_type,p_effective_date) from dual), 0, 10),-1)

497:
498: begin
499: l_proc := g_package||'get_history_id';
500: if (p_assignment_type = 'E' or p_assignment_type = 'C') then
501: select nvl(substr((select ghr_ss_views_pkg.get_people_ei_id_ason_date(p_person_id,p_information_type,p_effective_date) from dual), 0, 10),-1)
502: into l_history_id
503: from dual;
504: end if;
505: return (l_history_id);

Line 722: END ghr_ss_views_pkg;

718:
719: End get_assignment_end_date;
720: --End of bug fix 6781928
721:
722: END ghr_ss_views_pkg;