APPS.GHR_SF52_PRE_UPDATE dependencies on GHR_NOA_FAMILIES

Line 2167: ghr_noa_families nfa,

2163: -- Bug#3941541 Added the effective date condition.
2164: Cursor c_info_types is
2165: Select pit.information_type
2166: from ghr_pa_request_info_types pit,
2167: ghr_noa_families nfa,
2168: ghr_families fam
2169: where nfa.nature_of_action_id = p_pa_request_rec.first_noa_id
2170: and nfa.noa_family_code = fam.noa_family_code
2171: and fam.pa_info_type_flag = 'Y'