[Home] [Help]
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'
2172: and pit.noa_family_code = fam.noa_family_code