DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on HR_PERSON_NAME

Line 8850: SELECT hr_person_name.get_list_name(ppf.global_name, ppf.local_name) full_name

8846: l_target_sup_id NUMBER;
8847:
8848: CURSOR csr_person_full_name (p_sc_id IN NUMBER)
8849: IS
8850: SELECT hr_person_name.get_list_name(ppf.global_name, ppf.local_name) full_name
8851: FROM per_all_people_f ppf, per_personal_scorecards pps
8852: WHERE ppf.person_id = pps.person_id
8853: AND pps.scorecard_id = p_sc_id
8854: AND TRUNC(SYSDATE) between ppf.effective_start_date and ppf.effective_end_date;