APPS.GHR_SF52_PRE_UPDATE dependencies on GHR_NOA_FAMILIES

Line 2275: ghr_noa_families nfa,

2271: -- Bug#3941541 Added the effective date condition.
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'