DBA Data[Home] [Help]

APPS.GHR_CPDF_CHECK3 dependencies on GHR_HISTORY_API

Line 63: l_session ghr_history_api.g_session_var_type;

59: ,p_agency_subelement IN VARCHAR2
60: ,p_ethnic_race_info IN VARCHAR2 -- 17/11/2005 Raju 4567571(UPD45) Added this parameter
61: ) is
62:
63: l_session ghr_history_api.g_session_var_type;
64: l_noa_family_code ghr_families.noa_family_code%type;
65: Cursor c_noa_family_code IS
66: Select fam.noa_family_code
67: from ghr_noa_families nfa,

Line 279: ghr_history_api.get_g_session_var(l_session);

275: --
276: --upd47 26-Jun-06 Raju From 01-May-2006 Exclude 849
277: --upd49 08-Jan-07 Raju From 01-Jun-2004 Bug#5619873 Add 826,827
278: -- upd51 06-Feb-07 Raju From 01-Jan-2007 Bug#5745356 add noa 849,885,886,887,889
279: ghr_history_api.get_g_session_var(l_session);
280: if p_effective_date >= to_date('01/10/1998', 'dd/mm/yyyy') then
281: if p_effective_date < fnd_date.canonical_to_date('2006/05/01') then
282: if l_session.noa_id_correct is null then
283: if p_effective_date < fnd_date.canonical_to_date('2004/06/01') then