APPS.GHR_CPDF_CHECK3 dependencies on GHR_NATURE_OF_ACTIONS

Line 72: ghr_nature_of_actions where code = p_First_NOAC_Lookup_Code )

68: Select fam.noa_family_code
69: from ghr_noa_families nfa,
70: ghr_families fam
71: where nfa.nature_of_action_id in ( select nature_of_action_id from
72: ghr_nature_of_actions where code = p_First_NOAC_Lookup_Code )
73: and nfa.noa_family_code = fam.noa_family_code
74: and fam.update_hr_flag = 'Y';
75:
76: