APPS.GHR_CPDF_CHECK3 dependencies on GHR_NATURE_OF_ACTIONS

Line 70: ghr_nature_of_actions where code = p_First_NOAC_Lookup_Code )

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