DBA Data[Home] [Help]

APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on PER_PEOPLE_F

Line 150: select global_name from per_people_f

146: result_code out nocopy VARCHAR2 )
147: IS
148: cursor get_person_name(p_person_id per_all_people_f.person_id%TYPE)
149: is
150: select global_name from per_people_f
151: where person_id = p_person_id
152: and trunc(sysdate) between effective_start_date and effective_end_date;
153:
154: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)