APPS.HR_APPRAISALS_UTIL_SS dependencies on WF_ROLES

Line 634: FROM wf_roles wf

630:
631: CURSOR get_role (person_id per_all_people_f.person_id%TYPE)
632: IS
633: SELECT wf.NAME role_name
634: FROM wf_roles wf
635: WHERE wf.orig_system = 'PER' AND wf.orig_system_id = person_id;
636:
637: CURSOR get_global_name (p_person_id per_all_people_f.person_id%TYPE)
638: IS

Line 834: SELECT wf.orig_system_id from wf_roles wf

830: WHERE person_id = p_approver_id
831: AND sysdate BETWEEN effective_start_date AND effective_end_date;
832:
833: cursor csr_approver_id ( p_role in varchar2 ) is
834: SELECT wf.orig_system_id from wf_roles wf
835: WHERE wf.orig_system = 'PER'
836: AND wf.name = p_role;
837:
838: current_wkr_flag VARCHAR2(2);