DBA Data[Home] [Help]

APPS.GHR_SF52_UPDATE dependencies on GHR_NOA_FAMILIES

Line 598: from ghr_noa_families nof,

594:
595: cursor c_dual_sec_family_code(p_second_noa_id in number)
596: is
597: Select fam.noa_family_code
598: from ghr_noa_families nof,
599: ghr_families fam
600: where nof.nature_of_action_id = p_second_noa_id
601: and fam.noa_family_code = nof.noa_family_code
602: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'