DBA Data[Home] [Help]

APPS.GHR_APPROVED_PA_REQUESTS dependencies on GHR_FAMILIES

Line 1089: ( select noa_family_code from ghr_families

1085: where nature_of_action_id in
1086: ( select nature_of_action_id from ghr_nature_of_actions
1087: where code = p_noa_code )
1088: and noa_family_code in
1089: ( select noa_family_code from ghr_families
1090: where update_hr_flag = 'Y')
1091: and p_effective_date between NVL(start_date_active,p_effective_date)
1092: and NVL(end_date_active,p_effective_date);
1093: