DBA Data[Home] [Help]

APPS.GHR_VALIDATE_PERWSDPO dependencies on PER_PEOPLE_F

Line 542: FROM per_people_f per

538: ', Effective Date:'||par.effective_date||
539: ', Employee_Name:'||per.full_name||
540: ', SSN:'||per.national_identifier||
541: ', Updater:'||prh.user_name list_info
542: FROM per_people_f per
543: ,ghr_pa_routing_history prh
544: ,ghr_pa_requests par
545: WHERE par.to_position_id = p_position_id
546: AND par.effective_date >= p_effective_date