APPS.GHR_APPROVED_PA_REQUESTS dependencies on GHR_FAMILIES
Line 1145: ( select noa_family_code from ghr_families
1141: where nature_of_action_id in
1142: ( select nature_of_action_id from ghr_nature_of_actions
1143: where code = p_noa_code )
1144: and noa_family_code in 1145: ( select noa_family_code from ghr_families 1146: where update_hr_flag = 'Y')
1147: and p_effective_date between NVL(start_date_active,p_effective_date)
1148: and NVL(end_date_active,p_effective_date);
1149: