APPS.GHR_CPDF_CHECK3 dependencies on GHR_FAMILIES

Line 66: l_noa_family_code ghr_families.noa_family_code%type;

62: ,p_rating_of_record_pattern IN VARCHAR2 --non SF52 item Bug# 10189715
63: ) is
64:
65: l_session ghr_history_api.g_session_var_type;
66: l_noa_family_code ghr_families.noa_family_code%type;
67: Cursor c_noa_family_code IS
68: Select fam.noa_family_code
69: from ghr_noa_families nfa,
70: ghr_families fam

Line 70: ghr_families fam

66: l_noa_family_code ghr_families.noa_family_code%type;
67: Cursor c_noa_family_code IS
68: Select fam.noa_family_code
69: from ghr_noa_families nfa,
70: ghr_families fam
71: where nfa.nature_of_action_id in ( select nature_of_action_id from
72: ghr_nature_of_actions where code = p_First_NOAC_Lookup_Code )
73: and nfa.noa_family_code = fam.noa_family_code
74: and fam.update_hr_flag = 'Y';