APPS.GHR_CPDF_CHECK3 dependencies on GHR_FAMILIES

Line 64: l_noa_family_code ghr_families.noa_family_code%type;

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,
68: ghr_families fam

Line 68: ghr_families fam

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,
68: ghr_families fam
69: where nfa.nature_of_action_id in ( select nature_of_action_id from
70: ghr_nature_of_actions where code = p_First_NOAC_Lookup_Code )
71: and nfa.noa_family_code = fam.noa_family_code
72: and fam.update_hr_flag = 'Y';