DBA Data[Home] [Help]

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: