APPS.GHR_SF52_PRE_UPDATE dependencies on GHR_FAMILIES

Line 2276: ghr_families fam

2272: Cursor c_info_types is
2273: Select pit.information_type
2274: from ghr_pa_request_info_types pit,
2275: ghr_noa_families nfa,
2276: ghr_families fam
2277: where nfa.nature_of_action_id = p_pa_request_rec.first_noa_id
2278: and nfa.noa_family_code = fam.noa_family_code
2279: and fam.pa_info_type_flag = 'Y'
2280: and pit.noa_family_code = fam.noa_family_code