DBA Data[Home] [Help]

APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on PER_PEOPLE_F

Line 543: select global_name from per_people_f

539: result_code out nocopy VARCHAR2 )
540: IS
541: cursor get_person_name(p_person_id per_all_people_f.person_id%TYPE)
542: is
543: select global_name from per_people_f
544: where person_id = p_person_id
545: and trunc(sysdate) between effective_start_date and effective_end_date;
546:
547: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)